0 ×

XLS Format Merger

Continental Nodes for KNIME version 1.2.0.v202005250952 by Continental

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.

Input Ports

Icon
A XLS Formatter input port that shall be merged.
Icon
A XLS Formatter input port that shall be merged.

Output Ports

Icon
The XLS Formatter output port with the combined formatting instructions of all input ports.

Best Friends (Incoming)

Best Friends (Outgoing)

Installation

To use this node in KNIME, install Continental Nodes for KNIME from the following update site:

KNIME 4.3

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

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

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.