Excel Writer (XLS)

This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.

This node writes the input data table into a spreadsheet of a workbook. The files can then be read with other applications such as Microsoft Excel.

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 held by a spreadsheet of this format is 256 (all additional columns in the data table are truncated). If the input data table has more than 65536 rows, it is split into multiple spreadsheets (all stored in the created workbook).
.xlsx format: The Office Open XML format is the file format used by default from Excel 2007 onwards.

This nodes does not support writing in the 'xlsm' format.

Specifying a remote URL as the destination location will force the node to overwrite this file as it is not possible to determine whether this location already exists. If no extension is specified, the file will be written in the .xlsx format.

Options

Output location: Enter a valid file name or URL. You can also choose a previously selected location from the drop-down list, or select a file from the "Browse..." dialog.
Overwrite existing file: Existing files will be overwritten if this option is enabled. Otherwise the node will fail during execution to retain the original file and to avoid unintentional overwrite. Remote locations will always be overwritten.
Open file after execution: Opens the file after it has been successfully created. The file will be opened in the default application of the system. This might not be supported by every system and is not available for remote locations.
Sheet name: Name of the sheet that will be created. If left empty, the name of the input table will be used.
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 used for missing data values. If not specified, the corresponding data cell of the spreadsheet stays empty.
Autosize columns: Fits each column's width to its content.
Portrait/Landscape: Sets the print format to portrait or landscape.
Paper size: Sets the paper size in the print setup.
Exclude/Include columns: Select the columns that will be written in the file. If the columns in the input table should change, they will automatically be excluded.

Input Ports

: The data table to write out.

Output Ports

This node has no output ports

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

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.

Installation

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:

v5.3

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

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 5.3.0.v202406101353

On NodePit since: 2024-07-09

Last update: 2024-11-15

Tags: Deprecated

KNIME versions: Since v3.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!