Data Resource - Excel
About
xlsx or xls are supported tabular file data resource.
Attributes
An excel file has the following attributes.
| Name | Default Value | Description |
|---|---|---|
| headerRowId | 0 | The row id where the header is located (0 means no header and 1 the first line) |
| sheetName | The sheet name (Optional, first sheet by default) | |
| dateFormat | dd/mm/yyyy hh:mm:ss | The date format (ie Format Cells > Number > Custom) |
In Excel, dates are numeric cell with an applied date format.