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 name filter
Section titled “Sheet name filter ”A regular expression that filters the sheets that are read e.g. “^invoice” will only read data from sheets that starts with “invoice” - therefore, “invoice123” will be read, but “fooinvoice” will be ignored.
If not specified, all sheets in the spreadsheet will be read.
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.