Write to Spreadsheet writes data to an Excel spreadsheet as output from a dataflow.
File Properties Tab
The File Properties tab contains options for specifying the spreadsheet
and data to write from a dataflow.
Field Name |
Description |
---|---|
Server name | Indicates the file you select in the File name field is located on the Spectrum Technology Platformserver. |
File name | Specifies the path to the file. Click the ellipses button (...) to browse to the
file. Attention: If the Spectrum Technology Platform server is running on
Linux, remember that file names and paths on these platforms are case
sensitive.
|
Write Mode | Specifies how you want to write data in the spreadsheet in order to write into the
dataflow. You can create a spreadsheet at runtime using any of the following options.
Options are as following:
|
Sheet name | Specifies a sheet name in the spreadsheet to which you want to write data into the dataflow. |
Start writing from | Specifies either a row-column combination (A1 or B2 ..) or a column from where you want the data to be written. For the option Insert you need to provide both row & column. For the option Append you can only provide column as it ignores the row value. |
First row as column header | Specifies the first row in a file contains header information and not data. |
Fields Tab
The Fields tab defines columns, positions, types and nullable values for the fields in the file. For more information, see the following topic: