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 Background Colorizer18 %
- XLS Cell Formatter18 %
- XLS Font Formatter15 %
- XLS Row and Column Sizer11 %
- XLS Border Formatter11 %
- XLS Sheet Properties8 %
- XLS Format Merger6 %
- XLS Cell Merger3 %
- XLS Sheet Selector2 %
- XLS Conditional Formatter2 %
- Excel Writer2 %
- XLS Cell Commenter< 1 %
- XLS Hyperlinker< 1 %
- CASE Switch End< 1 %
- Cell to Model< 1 %
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
- Coloured_ColumnKNIME Hub
- Coloured_Column_SecondKNIME Forum
- Show all 37 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.