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.
Popular Predecessors
- XLS Cell Formatter18 %
- XLS Background Colorizer16 %
- XLS Font Formatter13 %
- XLS Row and Column Sizer13 %
- XLS Border Formatter8 %
- XLS Format Merger7 %
- XLS Sheet Properties4 %
- XLS Cell Merger4 %
- Excel Writer3 %
- XLS Sheet Selector3 %
- XLS Hyperlinker2 %
- CASE Switch End2 %
- XLS Cell Commenter2 %
- XLS Conditional Formatter2 %
- Cell to Model2 %
- Wait...2 %
Model Reader< 1 %
Views
- This node has no views
Workflows
20220527 Pikairos How to Dynamically Format and Color an Excel SheetKNIME Hub- Apply formatting to different sheets created in a loopKNIME Hub
- Automate Away - webinar demo workflowKNIME Hub
- CNP - QRT D5KNIME Hub
- CNP - QRT D51KNIME Hub
- Show all 43 workflows
Links
- No links available
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.