Format Multiple Excel Sheets

This workflow snippet provides you with an example of how you can set up a loop that iterates over each sheet in a file and use a Control Table node that generates a control table, the table simply serves as a template table containing certain tags for the cells, which are going to be formatted. In this example, we use Rule Engine to tag the first row as “header” and all the remaining rows as “body”. You can then use the Community Extension: Continental Nodes for KNIME for formatting your Excel file based on the tags. After the loop is completed, multiple XLS Formatting port objects are collected and merged into one before it is applied.