Hub
NodeNode / Manipulator

XLS Cell Merger

Community Nodes Continental XLS Formatter Formatter
Drag & drop
Like
Copy short link

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).

Node details

Input ports
  1. Type: Table
    Control Table
    XLS Control Table holding tags that define which parts of the sheet shall be merged.
  2. Type: XLS Formatter
    Optional XLS Formatter
    The XLS Formatter input port potentially holding previous formatting instructions that the instructions of this node shall be added to.
Output ports
  1. Type: XLS Formatter
    XLS Formatter
    The XLS Formatter output port holding the collected formatting instructions including the added formatting information from this node.

Extension

The XLS Cell Merger node is part of this extension:

Related workflows & nodes

  1. 06_XLS_CellMerger
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    knime > Examples > 99_Community > 05_Continental_Nodes_for_KNIME > 02_XLS_Formatter > 01_Tutorials > 06_XLS_CellMerger
  2. Excel Table with Header
    There has been no description set for this workflow's metadata.
    kathrin > Forum Questions > Excel Table with Header
  3. create an Excel file with a complex header with the help of Continental Excel nodes
    Excel Header Combine
    +2
    create an Excel file with a complex header with the help of Continental Excel nodes
    mlauber71 > Forum > 2022 > kn_forum_42140_excel_continental_nodes_complex_header
  4. 07 Conti Nodes - Zebra Table and Header
    kathrin > Forum Questions > 07 Conti Nodes - Zebra Table and Header