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 you want. While writing a file to an HDFS file server, the below
compression formats are supported:
Note: Include the appropriate extension in the file name, to
indicate the desired compression format to be used while writing
the file.
Attention: If the Spectrumâ„¢ Technology Platform server
is running on Unix or 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: