XLSX
Excel XLSX File
With this Source Type, simple Excel files can be read as a data source.
Important The Excel file must contain only one worksheet, the data or the header row must start in cell A1.
Parameters
| Parameter | Description |
|---|---|
| File Name | File to be read |
| Decimal Separator | Separator for decimal places |
| Thousands Separator | Separator for thousands places |
| Date Format | Possible entries: DMY, MDY, DYM, MYD, YDM, YMD |
| Header Row | Activate if the text file contains a header row; this will then be used as the field name in the transformation |