Icon

03_​XLS_​BackgroundColorizer

This example workflow is licensed under

This example workflow is licensed under
the MIT License. See LICENSE.txt in the
workflow directory for details.

Apply Formatting Instructions to XLS File Option 2: Multiple colors at once - direct colors Option 1: One Background Color + Pattern After having collected all the formattinginstructions from the XLS Formatter nodes,apply these to your XLS file. If you have a lot of different background colors to set, use acontrol table which directly provides the color code in RGB(red, green, blue) per cell (syntax 255/0/255 or #FF00FF) Select the background color for a given tag and set thebackground color and pattern fill. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.yellow header withpurple dotted patterndirectcolor codesin RGBD4:G40/0/255A1:G1headercustom color table,e.g. via a Rule EngineXLS Formatter(apply) XLS BackgroundColorizer XLS BackgroundColorizer XLS Control Tablefrom Cell Range XLS Control Tablefrom Cell Range Table Creator XLS ControlTable Merger Apply Formatting Instructions to XLS File Option 2: Multiple colors at once - direct colors Option 1: One Background Color + Pattern After having collected all the formattinginstructions from the XLS Formatter nodes,apply these to your XLS file. If you have a lot of different background colors to set, use acontrol table which directly provides the color code in RGB(red, green, blue) per cell (syntax 255/0/255 or #FF00FF) Select the background color for a given tag and set thebackground color and pattern fill. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.yellow header withpurple dotted patterndirectcolor codesin RGBD4:G40/0/255A1:G1headercustom color table,e.g. via a Rule EngineXLS Formatter(apply) XLS BackgroundColorizer XLS BackgroundColorizer XLS Control Tablefrom Cell Range XLS Control Tablefrom Cell Range Table Creator XLS ControlTable Merger

Nodes

Extensions

Links