The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at
http://knime.com.
XLS Writer
This node writes out the datatable coming through its input
port into a spreadsheet of a workbook. The files can be read
then with other applications like Microsoft Excel, for
example. The maximum number of columns held by a spreadsheet
is 256 (all additional columns in the datatable are
truncated). If the input datatable has more than 65536 rows
it is split into multiple spreadsheets (all stored in the
created workbook).
Dialog Options
- Output file location
-
Enter a valid file name. You can also choose a previously
selected file from the drop-down list, or select a file from
the "Browse..." dialog.
- Overwrite existing file
-
If checked, the output file will be overridden if it exists.
If unchecked, the node will fail during execution in order to
retain the original file and to avoid unintentional overwrite.
- Output file location
-
Enter a valid file name. You can also choose a previously
selected file from the drop-down list, or select a file from
the "Browse..." dialog.
- Write column header
-
If checked, the column names are written out in the first
row of the spreadsheet.
- Write row ID
-
If checked, the row IDs are added to the output, in the
first column of the spreadsheet.
- Missing Value Pattern
-
Enter a pattern that is set for missing data values. If not
specified, the corresponding datacell of the spreadsheet
stays empty.
Ports
Input Ports
0 |
The Datatable to write out.
|
This node is contained in KNIME POI Plug-in
provided by KNIME GmbH, Konstanz, Germany.