This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementXLS Format MergerThe 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.
Views
- This node has no views
Workflows
21_XLS_PortMergerKNIME Hub- 22_XLS_MultipleSheetsKNIME Hub
- 23_XLS_MultipleSheetsViaLoopKNIME Hub
- 2nd Vernalis Benchmark example for Excel nodesKNIME Forum
- Format Multiple Excel SheetsKNIME Hub
- Show all 9 workflows
Links
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.