Write to Spreadsheet

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:
Create or Overwrite
Creates a new file and replaces the existing data in the output file each time the dataflow runs.
Insert
Adds the dataflow's output to the mapped area and shifts the data down if already present there.
Append
Adds the dataflow's output to the end of the file without erasing the file's existing data.
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: