Target type is Excel File

Advanced ETL Processor gives the user various options to generate Excel files.

Creating new file:

Sheet Name Create new file? Add data starting from Sheet Exists? Range Exists?Notes
SheetName Yes Top No No New file is created with the Sheet called “SheetName”, data is inserted from the top left corner
SheetNameYesCellNoNoNew file is created with the Sheet called “SheetName”, data is inserted from the Cell
SheetNameYesLast RowNoNoNew file is created with the Sheet called “SheetName”, data is inserted from the top left corner
SheetName.RangeNameYesTopNoNoNew file is created with the Sheet called “SheetName”, data is inserted from the top left corner, new range called “RangeName” is created with the size equal to the populated data
SheetName.RangeNameYesCellNoNoNew file is created with the Sheet called “SheetName”, data is inserted from the Cell, new range called “RangeName” is created with the size equal to the populated data
SheetName.RangeNameYesLast RowNoNoNew file is created with the Sheet called “SheetName”, data is inserted from the top left corner, new range called “RangeName” is created with the size equal to the populated data

Adding/ updating data in the existing Excel file:

Sheet Name Create new file? Add data starting from Sheet Exists? Range Exists?Notes
SheetNameNoTopNoNoNew Sheet is created called “SheetName”, data is inserted from the top left corner
SheetNameNoCellNoNoNew Sheet is created called “SheetName”, data is inserted from the Cell
SheetNameNoLast RowNoNoNew Sheet is created called “SheetName”, data is inserted from the top left corner
SheetName.RangeNameNoTopNoNoNew Sheet is created “SheetName”, data is inserted from the top left corner, new range called “RangeName” is created with the size equal to the size of populated data
SheetName.RangeNameNoCellNoNoNew Sheet is created “SheetName”, data is inserted from the Cell, new range called “RangeName” is created with the size equal to the size of populated data
SheetName.RangeNameNoLast RowNoNoNew Sheet is created “SheetName”, data is inserted from the top left corner, new range called “RangeName” is created with the size equal to the size of populated data
SheetNameNoTopYesNoWithin Sheet “SheetName”, data is replaced starting from the top left corner; the rest of the data within Sheet is left intact.
SheetNameNoCellYesNoWithin Sheet “SheetName”, data is replaced starting from the cell, the rest of the data within Sheet is left intact
SheetNameNoLast RowYesNoWithin Sheet “SheetName”, data is inserted starting from the last empty row; the rest of the data within Sheet is left intact.
SheetName.RangeNameNoTopYesNoWithin Sheet “SheetName”, data is replaced starting from the top left corner, the rest of the data within Sheet is left intact, than new range called “RangeName” is created with the size equal to the size of populated data
SheetName.RangeNameNoCellYesNoWithin Sheet “SheetName”, data is replaced starting from the cell, the rest of the data within Sheet is left intact, than new range called “RangeName” is created with the size equal to the size of populated data.
SheetName.RangeNameNoLast RowYesNoWithin Sheet “SheetName”, data is is inserted starting from the last empty row, the rest of the data within Sheet is left intact, than new range called “RangeName” is created with the size equal to the size of populated data.
SheetName.RangeNameNoTopYesYesWithin Sheet “SheetName”, data is replaced starting from the top left corner of the range “RangeName”, the rest of the data within Sheet is left intact, than range “RangeName” size is set to the size of newly populated data.
SheetName.RangeNameNoCellYesYesWithin Sheet “SheetName”, data is replaced starting from the cell, the rest of the data within Sheet is left intact, than range “RangeName” size is set to the size of newly populated data.
SheetName.RangeNameNoLast RowYesYesWithin Sheet “SheetName”, data is inserted starting from the last row of the range “RangeName” +1, the rest of the data within Sheet is left intact, than range “RangeName” size increased by the size of newly populated data

Excel cell formatting:

Notes:

1 To create date fields use standard Date Format function

2 Do not use multiple writers within same transformation to populate same excel file (Like on the picture below). Create separate transformations and execute them sequentially from the package.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetle/processing_data/writer/excel.txt
  • Last modified: 17/09/2018 10:34
  • by admin