import-from-excel-file

Description

import-from-excel-file adaptor imports data from an Excel file in XLSX format.

Inputs

file Type: file Required: Yes The spreadsheet file in Office Open XML SpreadsheetML file format (.xlsx).

sheet name Type: text Required: No The name of the sheet (tab) from which to import the data. If unspecified, the first sheet will be used.

range Type: text Required: No A valid range of cells (e.g., A1:L512) that contain data. If unspecified, the entire sheet will be included.

skip Type: list Required: No A list of row numbers to be ignored. If unspecified, then all rows in the range will be imported.

Outputs

data Type: datatable A datatable containing the imported data.

Examples

Example 1: Default behaviour.

Inputs:

file: data.xlsx

sheet name: null (empty)

range: null (empty)

skip: null (empty)

Outputs:

data:

id	latitude	longitude
Sample A	4.642276772	-8.17536836
Sample B	5.063345736	-9.051186684
Sample C	5.063345736	-9.051186684
Sample D	4.638091468	-8.17536836

-> Imported the excel file data.xlsx into Data-flo.

Example 2: Import data from excel file within a specified range.

Inputs:

file: data.xlsx

sheet name: Sheet1

range: A1:C4

skip: null (empty)

Outputs:

data:

id	latitude	longitude
Sample A	4.642276772	-8.17536836
Sample B	5.063345736	-9.051186684
Sample C	5.063345736	-9.051186684

-> Imported the excel file data.xlsx from cell range A1:C4.

Example 3: Import data from excel file data.xlsx, skipping specific rows.

Inputs:

file: data.xlsx

sheet name: Sheet1

range: null (empty)

skip:

1. 2

2. 4

Outputs:

data:

id	latitude	longitude
Sample A	4.642276772	-8.17536836
Sample C	5.063345736	-9.051186684

-> Imported the excel file data.xlsx and skipped rows 2 and 4.