This load type loads data into Microsoft Excel files (type XLSX). You can either create new files or load data into existing files. This load allows a maximum of 1,048,575 rows, which is the maximum allowed by the XLSX file standard.
|Data Source||Source of the Excel load|
|Tree format||See Overview of Tree Formats|
|Target connection||A connection of type Microsoft Excel File|
|Sheet name||Name of the worksheet in the workbook.|
|Header||If set a header row is created in the workbook.|
|Start Cell||If set, the data is written in the workbook to a range with this starting cell.* Default value: A1|
|Start Cell for Styles||If set, the styles for the created Excel cells are taken from the row in the workbook with this starting cell so different (numerical) cell formats can be defined for the individual source columns. If not set, a default style is used for all columns. This option can only be used if the workbook already exists and the mode is either “add” or “update”. In the latter case, the start cell for styles has to be defined in a different worksheet.
Note: Excel does not automatically recognize the functions that are part of the Excel Load, and automatically displays them as strings. You must manually edit the cells containing the Excel functions.
*In loads using Add mode: if the start cell set in advanced settings is greater than the existing row count, then data is appended from the defined start cell. Otherwise, data is appended from the existing row count + 1.