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.