Open Excel file as DataReader
Provides a DataReader for reading a forward-only stream of rows from an Excel sheet.
Properties
| Name | Type | Description |
|---|---|---|
| Title | Optional | The title of the action. |
| File contents | Required | The contents of the file, provided as either a stream or a byte array. |
| Sheet name | Optional | The name of the sheet(s) from which to read data. If you don't specify anything, data is read from the first sheet in the file. When specifying multiple sheets, use a semicolon to separate sheet names. In the rare case that a sheet name contains a semicolon, use square brackets around the sheet name. |
| Data start row | Optional | The row number of the first row to read. If the worksheet has a header row, Data start row is typically 2 |
| Column mapping | Required | Defines the mapping between Excel column letters and business object property names. |
| Reader variable name | Optional | The name of the variable you can use to reference the DataReader in other actions. |
Automatic column mapping
Columns can be mapped automatically by using the "Map from sample file" option.
