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. It is also possible to load password-protected XLSX files in Excel load.

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.*

Note: file load with target file location "JedoxFiles" is only supported on "create" mode, i.e. it does not work on "add" and "update" modes.

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.

Example: Sheet2!B3

Do not generate empty file

If checked, rows that do not contain data will not generate an element.

If not checked, such rows will generate an element with null value.

Notes:

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.
This load allows a maximum of 1,048,575 rows, which is the maximum allowed by the XLSX file standard.

*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.

Updated April 8, 2025