Function Name |
Excel Data Target | ||||||
Category |
Excel | ||||||
Icon |
![]() |
||||||
Description |
Writes data to an Excel Spreadsheet (Worksheet, Table or Range). | ||||||
Inputs |
|
||||||
Outputs |
|
||||||
Properties |
|
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.
The name of the component, must be unique within the transform
Allows the column definitions to be manually edited.
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)
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.
The encoding used to write the text data to a file.
If checked then all the column headings are written onto the first line of the file.
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.