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 formatting instructions from the XLS Formatter nodes, apply these to your XLS file.
If you have a lot of different background colors to set, use a control 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 the background color and pattern fill.
This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow directory for details.
D4:G4 0/0/255
XLS Control Table from Cell Range
A1:G1 header
XLS Control Table from Cell Range
custom color table, e.g. via a Rule Engine
Table Creator (deprecated)
XLS Control Table Merger
yellow header with purple dotted pattern
XLS Background Colorizer
direct color codes in RGB
XLS Background Colorizer
XLS Formatter (apply) (deprecated)

Nodes

Extensions

Links