0 ×

04_​XLS_​BorderFormatter

Workflow

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

Download

Get this workflow from the following link: Download

Nodes

04_​XLS_​BorderFormatter consists of the following 8 nodes(s):

Plugins

04_​XLS_​BorderFormatter contains nodes provided by the following 3 plugin(s):