Excel Load

image_pdfimage_print

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

 

image_pdfimage_print
Was this post helpful?
NoYes (-1 rating, 1 votes)
Loading...