Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • XLS Format Merger
NodeNode / Manipulator

XLS Format Merger

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

The XLS Format Merger node combines two or more XLS formatting instruction sets (i.e. ports) to one.

This node can be used to combine formatting instructions set for different sheets (using the XLS Sheet Selector node) prior to the XLS Formatter (apply) node. When applied to the same sheet, properties are merged at the lowest detail level (e.g. cell A1's font formatted as bold merged with A1 font italic yields bold and italic). Thereby, the upper input port overwrites a lower one in case of conflicting information (e.g. two different font colors for the same cell). In case of overlapping cell merge ranges, this node fails. Be aware that when merging the default sheet and a named sheet, this can cause the XLS Formatter (apply) node to fail later, if both of these point to the same XLS sheet.

Node details

Input ports
  1. Type: XLS Formatter
    XLS Formatter
    A XLS Formatter input port that shall be merged.
  2. Type: XLS Formatter
    XLS Formatter
    A XLS Formatter input port that shall be merged.
Output ports
  1. Type: XLS Formatter
    XLS Formatter
    The XLS Formatter output port with the combined formatting instructions of all input ports.
input (Dynamic Inport)
A XLS Formatter input port that shall be merged.
  1. Type: XLS Formatter

Extension

The XLS Format Merger node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Coloured_Column
    mythxahir > Public > Coloured_Column
  2. Go to item
    Apply formatting to different sheets created in a loop
    kathrin > Forum Questions > Apply formatting to different sheets created in a loop

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