Icon

04_​XLS_​BorderFormatter

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 Table
Option 2: Multiple borders at once - all tags
Option 1: One Border Style and Color
After having collected all formatting instructions from the XLS Formatter nodes, apply these to your XLS file.
If you have adjacent areas to tag for border setting, don't bother to define tags yourself, but use the original data and activate the 'all tags' option.
The XLS Border Formatter node changes cell borders of a given range (not necessarily rectangular) specified by tags in a control table. You can select which borders of the matching cells shall be displayed in which style and optionally also change the border color accordingly.
This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow directory for details.
unformatted data table
Excel Reader (XLS) (deprecated)
D4:G5 tag1
XLS Control Table from Cell Range
input table control table
XLS Control Table Generator
inner red double border for tag1
XLS Border Formatter
C to customer
Constant Value Column (deprecated)
outer thick border for all tags
XLS Border Formatter
only first row
Row Filter (deprecated)
XLS Formatter (apply) (deprecated)

Nodes

Extensions

Links