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.

Views

This node has no views

Workflows

• 06_XLS_CellMergerKNIME Hub
• 07 Conti Nodes - Zebra Table and HeaderKNIME Hub
• 2nd Vernalis Benchmark example for Excel nodesKNIME Forum
• Create Excel PivotsKNIME Hub
• Dynamic Row formattingKNIME Hub
• Show all 18 workflows

Links

• No links available

Developers