This node writes the input data table into a spreadsheet of an Excel file, which can then be read with other applications such as Microsoft Excel. The node can create completely new files or append data to an existing Excel file. When appending, the input data can be appended as a new spreadsheet or after the last row of an existing spreadsheet. By adding multiple data table input ports, the data can be written/appended to multiple spreadsheets within the same file.
The node supports two formats chosen by file extension:
.xls
format: This is the file format which was used by default up until Excel 2003. The maximum
number of columns and rows held by a spreadsheet of this format is
256 and 65536 respectively.
.xlsx
format: The Office Open XML format is the file format used by default from Excel 2007 onwards.
The maximum number of columns and rows held by a spreadsheet of this format is 16384 and 1048576 respectively.
If the data does not fit into a single sheet, it will be split into multiple chunks that are written
to newly chosen sheet names sequentially. The new sheet names are derived from the originally
selected sheet name by appending " (i)" to it, where i=1,...,n.
When appending to a file, a sheet may already exist. In this case the node will
(according to its settings) either replace the sheet, fail or append rows after the last row in that
sheet. This can be used to append data to an Excel file without having to create a new sheet
name once the original sheet is full by just selecting the original sheet name. The data will
be appendend to the last sheet in the name sequence. The original sheet name does not have to be changed.
This node does not support writing files in the '.xlsm' format, yet appending is supported.
This node can access a variety of different file systems. More information about file handling in KNIME can be found in the official File Handling Guide.
Allows you to specify a password to protect the output file with. In case the "append" option is selected and the file already exists, the password must be valid for the existing file.
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.
To use this node in KNIME, install the extension KNIME Excel Support from the below update site following our NodePit Product and Node Installation Guide:
A zipped version of the software site can be downloaded here.
Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.