Excel Load

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.

Main settings
Data Source  Source of the Excel load
Tree format See Overview of Tree Formats
Target connection A connection of type Microsoft Excel File
Mode
create If the workbook already exists, it is removed and a new workbook is created.
update The workbook is created if not yet existing. If the worksheet already exists, it is removed and a new worksheet is created.
add The workbook and the worksheet are created if not yet existing. If the worksheet already exists, the source data are appended to the existing data.*
Sheet name Name of the worksheet in the workbook.
Header If set a header row is created in the workbook.
Advanced settings
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.

Example: Sheet2!B3

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.