XLS Control Format Template 3

Use this in conjunction with the XLS Control Table Auto Tag Generator component.

This component works as a "template". Save it locally and detach from the original. Then you can modify the settings, or add additional formatting options internally and save as a template component locally with a different name.

sets headings to grey background
set columns to auto width
freeze header row, and
auto filter

@takbb Brian Bates Updated 4 October 2022

Options

Freeze Panes
Freeze Top Row and Left column?
Name of Excel Sheet
Enter the name of the sheet in Excel to format

Input Ports

Icon
XLS Control Table pass through. By chain linking both Control Table and Formatting nodes, the worksheet remains tidier
Icon
Formatting input from another XLS Formatting Node or XLS Auto Tag Generator component

Output Ports

Icon
Pass this on to another XLS Formatting component

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2023-08-01
Last update: 2026-01-21
Created with KNIME version: v4.7.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!