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.

The Fields tab defines columns, positions, types and nullable values for the fields in the file. For more information, see the following topic: