Excel Read Bulk
ExcelReadBulk reads the rows of a sheet in an Excel spreadsheet file without requiring the columns to be defined at design time.
The first row of the sheet is treated as the header row and is not returned as data. Each of the remaining rows is returned one at a time in the Row execution path, as a list of text values in the order in which the columns appear in the sheet.
Use ExcelReadHeader to read the column names of the sheet.
Properties
Section titled “Properties ”File path
Section titled “File path ”The file path of the Excel file to read.
Sheet
Section titled “Sheet ”The name of the sheet to read, or \n to read the n’th sheet (1-based), e.g. \2 reads the second sheet in the workbook.
If not specified, the first sheet in the spreadsheet is read.
An exception is thrown if the specified sheet name does not exist in the workbook, or if the specified sheet number is out of range.
Execution path
Section titled “Execution path ”Executed once for each data row in the sheet. It contains a single object with the following property:
- Content: a list of text values containing the cell values of the row, in column order.
All cell values are returned as text, regardless of how the cells are formatted in the spreadsheet.