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 instructionsfrom the XLS Formatter nodes, apply these toyour XLS file. If you have adjacent areas to tag for border setting, don't bother todefine tags yourself, but use the original data and activate the 'all tags'option. The XLS Border Formatter node changes cell bordersof a given range (not necessarily rectangular) specifiedby tags in a control table. You can select which bordersof the matching cells shall be displayed in which styleand optionally also change the border coloraccordingly. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.unformatteddata tableinput tablecontrol tableD4:G5tag1inner reddouble borderfor tag1outer thick borderfor all tagsonly first rowC tocustomerExcel Reader (XLS) XLS ControlTable Generator XLS Formatter(apply) XLS Control Tablefrom Cell Range XLS BorderFormatter XLS BorderFormatter Row Filter ConstantValue Column 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 instructionsfrom the XLS Formatter nodes, apply these toyour XLS file. If you have adjacent areas to tag for border setting, don't bother todefine tags yourself, but use the original data and activate the 'all tags'option. The XLS Border Formatter node changes cell bordersof a given range (not necessarily rectangular) specifiedby tags in a control table. You can select which bordersof the matching cells shall be displayed in which styleand optionally also change the border coloraccordingly. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.unformatteddata tableinput tablecontrol tableD4:G5tag1inner reddouble borderfor tag1outer thick borderfor all tagsonly first rowC tocustomerExcel Reader (XLS) XLS ControlTable Generator XLS Formatter(apply) XLS Control Tablefrom Cell Range XLS BorderFormatter XLS BorderFormatter Row Filter ConstantValue Column

Nodes

Extensions

Links