Function Name	Excel Data Target
Category	Excel
Icon
Description	Writes data to an Excel Spreadsheet (Worksheet, Table or Range).
Inputs	Filename Source file to read data from, if this input is not connected then the filename provided in the 'Default Source File' property Row A row is create for each line read form the source file Child Items Row contain a number of child items that reflect the fields defined when the component is created.
Outputs	None
Properties	Default Source File The default data file to read from. This is used if the input connection point 'Filename' is not connected. Store Relative Indicates if paths should be stored relative to the transform, or as absolute paths. Execution Order If the transform contains multiple Output Components then this determines the order in which they are executed

 

Creating an Excel File Target

When the Excel Writer component is dragged onto a transform a setup wizard is launched to guide you through the creation of the data target.

When writing to an Excel spreadsheet you must first determine the structure of the data area to write into. We recommend that you use an existing spreadsheet to simplify this process.

Clicking on 'Read structure from an existing sample document' button will run the Excel Reader Wizard to allow you to select the data range.

 

If you chose to select the data range from an existing spreadsheet, this page will be pre-populated with the range information you specified.

If not, you can manually specify the required range information.

You can also specify the option to 'Write Column Names' into the output.

 

The final screen allows you to specify the output filename to use.

 

 

Once you press Finish the new Text Data target is added to the transform and can be used as any other data target is.

Property Pages

 

Name

The name of the component, must be unique within the transform

 

 

Edit Columns

Allows the column definitions to be manually edited.

Default output filename

If the writer component does not have a connector to the 'Filename' input then the filename the data is written to is taken from this property.

If the connection point 'Filename' is connected, then this property is ignored (and can be blank)

Store as relative path

Indicates that the filename is to be resolved relative to the data mapping file (.dm). If the transform is compiled the filename will be resolved relative to the compiled exe.

Default Encoding

The encoding used to write the text data to a file.

Write column heading on first line

If checked then all the column headings are written onto the first line of the file.

 

 

 

Inputs

The component has a root input called 'Filename', each value provided to this is treated as a filename and a new Excel document is created.

If the 'Filename' input is not connected then the "Default target file" is used (see properties window).

The child inputs are all specific to the Text standard you selected when the component was created.