Icon

06_​XLS_​CellMerger

This example workflow is licensed under

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

Option 2: Multiple merges at once - all tags Option 1: One tag to merge Apply Formatting Instructions to XLS File After having collected all formatting instructionsfrom the XLS Formatter nodes, apply these toyour XLS file. If you have a lot of different merges, select all tags to merge allof your tags individually. For this to work all the tags have to bein a rectangular range. 1x1 ranges will be ignored. Merge cells based on a rectangular tag range. Thecohesive tag range has to be rectangular. The contentof the merged cell will be the top left cell of therespective range. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.unformatteddata tableinput tablecontrol tableB1:C1tag1mergetag1merge all tagsindividuallyExcel Reader (XLS) XLS ControlTable Generator XLS Formatter(apply) XLS Control Tablefrom Cell Range XLS Cell Merger XLS Cell Merger Option 2: Multiple merges at once - all tags Option 1: One tag to merge Apply Formatting Instructions to XLS File After having collected all formatting instructionsfrom the XLS Formatter nodes, apply these toyour XLS file. If you have a lot of different merges, select all tags to merge allof your tags individually. For this to work all the tags have to bein a rectangular range. 1x1 ranges will be ignored. Merge cells based on a rectangular tag range. Thecohesive tag range has to be rectangular. The contentof the merged cell will be the top left cell of therespective range. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.unformatteddata tableinput tablecontrol tableB1:C1tag1mergetag1merge all tagsindividuallyExcel Reader (XLS) XLS ControlTable Generator XLS Formatter(apply) XLS Control Tablefrom Cell Range XLS Cell Merger XLS Cell Merger

Nodes

Extensions

Links