XLS Formatter (apply)

This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementXLS 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).

Options

IO Options

Input File
File-path of your raw input xlsx file.
Output File
File-path of your formatted output xlsx file.

Advanced Options

overwrite output file
If a file already exists in the output directory the file will either be over-written or an error will be generated.
open output file after execution
Once the node execution has been finished, the output xlsx file will be opened.

Input Ports

Icon
The XLS Formatter input port holding the collected formatting instructions for your xlsx file.

Output Ports

This node has no output ports

Popular Predecessors

Popular Successors

  • Excel Writer18 %
  • Variable Loop End7 %
  • Variable Loop End6 %
  • XLS Formatter (apply)6 %
  • Merge Variables5 %
  • Wait...5 %
  • Send Email5 %
  • Table Creator3 %
  • Numeric Row Splitter3 %
  • Column Filter3 %
  • File Download Widget3 %
  • XLS Coloured Writer2 %
  • Java Edit Variable2 %
  • Loop End2 %
  • IF Switch2 %
  • Component Output2 %
  • Excel Reader (XLS)2 %
  • Excel Reader2 %
  • String to Path (Variable)2 %
  • String Manipulation (Variable)2 %
  • CASE Switch Variable (End)2 %
  • Delete Files/Folders2 %
  • Merge Variables1 %
  • Table to HTML1 %
  • Excel Sheet Appender (XLS) (deprecated)1 %
  • Excel Writer (XLS) (deprecated)1 %
  • Read Excel Sheet Names1 %
  • XLS Format Merger< 1 %
  • XLS Sheet Selector< 1 %
  • Excel Password Manager< 1 %
  • Delete Files< 1 %
  • Upload< 1 %
  • Catch Errors (Var Ports)< 1 %
  • Active Branch Inverter< 1 %
  • Variable to Table Column< 1 %
  • Table Row to Variable< 1 %
  • Variable to Table Row (deprecated)< 1 %
  • Variable to Table Row< 1 %
  • Chunk Loop Start< 1 %
  • Column Resorter< 1 %
  • Row Filter< 1 %
  • Round Double< 1 %
  • RowID< 1 %
  • Timer Info< 1 %
  • Model to Cell< 1 %
  • Excel Reader (XLS)< 1 %
  • Excel Writer (XLS)< 1 %
  • Excel Sheet Appender (XLS) (deprecated)< 1 %
  • Path to String (Variable)< 1 %
  • File Download< 1 %

Views

This node has no views

Workflows

Links

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.12
Plugin provider: Continental
Plugin version: 1.7.0.v202604281413
On NodePit since: 2026-07-06
Last update: 2026-07-21
Tags: Deprecated
KNIME versions: Since v3.7

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

Try NodePit Runner!