XLS Cell Merger

The XLS Cell Merger node merges the cells for given ranges of input tags.

Tags in the provided XLS Control Table must appear in rectangular ranges. A single tag may re-appear, as long as two ranges of the same tag share at most a cell's corner, but not a cell's border. In this case, multiple ranges will be added based on the same tag.

Optionally, all distinct tags can be used instead of a single one (see below).

Options

Tag Selection

applies to tag (single tag only): Tag in your XLS Control Table that defines the merge range(s).
applies to all tags: Instead of specifying a single tag, the Cell Merger is applied repetitively to all distinct tags found in the control table. Note that in this case, no comma-separated tag list splitting is applied but the full cell content qualifies as a tag.
This option eases definition of adjacent merge ranges based on the original data table's values.

Input Ports

: XLS Control Table holding tags that define which parts of the sheet shall be merged.
: The XLS Formatter input port potentially holding previous formatting instructions that the instructions of this node shall be added to.

Output Ports

: The XLS Formatter output port holding the collected formatting instructions including the added formatting information from this node.

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 Continental Nodes for KNIME from the below update site following our NodePit Product and Node Installation Guide:

v5.2

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

Plugin provider: Continental

Plugin version: 1.4.1.v202305230618

On NodePit since: 2023-12-06

Last update: 2024-04-19

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!