0 ×

XLS Writer

DeprecatedKNIME POI Plug-in version 4.3.0.v202011211950 by KNIME AG, Zurich, Switzerland

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).

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.

Input Ports

Icon
The Datatable to write out.

Best Friends (Incoming)

Installation

To use this node in KNIME, install KNIME Excel Support from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.