Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • XLS Cell Merger
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    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. Go to item
    Excel Table with Header
    There has been no description set for this workflow's metadata.
    kathrin > Forum Questions > Excel Table with Header
  3. Go to item
    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. Go to item
    07 Conti Nodes - Zebra Table and Header
    kathrin > Forum Questions > 07 Conti Nodes - Zebra Table and Header

No known nodes available

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits