xlsx or xls are supported tabular file data resource.
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.