Icon

Colour Spreadsheet

Demo of formatting entire rows based on colour coding

file 1file 2join "files" by Keyto compareGenerate control tableDefine rulesfor row colourPopulate all cells withrow colourremove additionalcolumnwrite data tabletoexcel filecomponent to create a new pathvariable with samefilename but -f suffixread original fileand apply formattingto new file with -f suffix. Red BackBlue BackGreen BackYellow BackWhite fore for RedWhite fore for BlueTable Creator Table Creator Joiner XLS ControlTable Generator Rule Engine String Manipulation(Multi Column) Column Filter Excel Writer Edit PathVariable Filename XLS Formatter(apply) XLS BackgroundColorizer XLS BackgroundColorizer XLS BackgroundColorizer XLS BackgroundColorizer XLS Font Formatter XLS Font Formatter file 1file 2join "files" by Keyto compareGenerate control tableDefine rulesfor row colourPopulate all cells withrow colourremove additionalcolumnwrite data tabletoexcel filecomponent to create a new pathvariable with samefilename but -f suffixread original fileand apply formattingto new file with -f suffix. Red BackBlue BackGreen BackYellow BackWhite fore for RedWhite fore for BlueTable Creator Table Creator Joiner XLS ControlTable Generator Rule Engine String Manipulation(Multi Column) Column Filter Excel Writer Edit PathVariable Filename XLS Formatter(apply) XLS BackgroundColorizer XLS BackgroundColorizer XLS BackgroundColorizer XLS BackgroundColorizer XLS Font Formatter XLS Font Formatter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: bbate
Created at: 2023-10-08
On NodePit since: 2023-10-09
Last update: 2024-12-23
Created with KNIME version: v4.7.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!