Write Excel

Previous Top Next

The Write Excel component allows you to write data to a Microsoft Excel Spreadsheet. Data can be written to the file in one of two ways:

· Populating all data from a dataset starting at a specific Column and Row Index

· Populating specific cells

An optional template can be specified with preformatted headings and column layouts or it can also function as an existing spreadsheet that will be updated.

File Name	Specify the path to the output Excel File.
Template	Specify the optional path to the Excel template. This is an empty Excel spreadsheet that will be populated with data if you need Macros or special cell formatting in the Excel spreadsheet.
Worksheet	Specify the name of the worksheet to populate data with, if you leave it blank it will use the default active worksheet.

To populate specific cells

Column	Enter the column index for the new value in the spreadsheet.
Row	Enter the row index for the value in the spreadsheet.
Value	Enter the value or expression to insert into the cell.

To populate all data from a dataset

Dataset	Specify the name of the dataset to populate from.
Start Column and Start Row	The cells to start populating from.
Populate Column Names	Check this option if you want to include the column names read from the dataset.