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 |
|---|---|---|
| HEADER_ROW_ID | 0 | The row id where the header is located (0 means no header and 1 the first line) |
| SHEET_NAME | The sheet name (Optional, first sheet by default if not set) | |
| TIMESTAMP_FORMAT | yyyy-MM-dd HH:mm:ss | The timestamp format (ie Format Cells > Number > Custom) |
| DATE_FORMAT | yyyy-MM-dd | The date format (ie Format Cells > Number > Custom) |
In Excel, dates are numeric cell with an applied format, when we write:
Type supported
Excel files supports natively the following SQL data type:
We returns
We enforce the type on the whole column even if Excel supports the type by column.
During a transfer, we support all data type. Ie if the target column is:
- a Integer, the Decimal value will be transformed into a Integer
- a Time, the Varchar value 08:00 will be transformed in Time