XLS Formatter (apply)

The XLS Formatter (apply) node applies the chained commands from XLS Formatter nodes to an unformatted xlsx file.

All previous XLS Formatter nodes do not modify any xlsx files yet but prepare the formatting steps to be taken here. The input file may not contain any formatting yet (except very few styles that are tolerated due to date/time values handling).

This node supports the path flow variable to specify the source and destination location. To convert the created path column to a string column which is required by some nodes that have not been migrated yet you can use the Path to String node. For further information about file handling in general see the File Handling Guide.

Options

File

Select a .xlsx file to apply the formatting to.

File

The file to write the formatted .xlsx to.

Create missing folders

If enabled, missing folders in the specified path will be created automatically.

If exists

Specify the behavior of the node in case the output file already exists.

Overwrite: Will replace any existing file.
Fail: Will issue an error during the node's execution (to prevent unintentional overwrite).

Preserve source file's cell number formats

When selected, the original number formats from the source file (e.g. date cells written by KNIME) will be preserved in the output file. When unchecked, default formatting may be applied.

Open output file after execution

Once the node execution has been finished, the output .xlsx file will be opened automatically. Note: Only files on your local file system can be opened.

Input Ports

: The XLS Formatter input port holding the collected formatting instructions for your xlsx file.
…: The source file system connection.
…: The destination file system connection.

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 XLS Formatting & Utilities from the below update site following our NodePit Product and Node Installation Guide:

v5.10

Plugin provider: Continental

Plugin version: 1.7.0.v202602021528

On NodePit since: 2026-02-18

Last update: 2026-03-01

Tags: Modern UI

KNIME versions: Since v4.4

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

Try NodePit Runner!