Icon

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.

Modifying multiple sheets with a format pattern in an Excel fileThis workflow iterates over multiple sheets in an Excel file using a loop and uses the control table to tag the "header" and "body" for each sheet that has to be formatted. After the completion of the loop, a PortObject for format pattern is genrated for each sheet which is then megred into one, before it is applied. Reading excel file with multiple sheetsGenerate control tableDefine rules for header and bodyGenerate control table with the tags "header and "body"Iterate over sheetsReading one sheet at a timeCollect XLS formatting for all sheets as PortObjectscopy/pastable componentthat recursively mergesa column's XLS Formatterport objects to oneWrite a new Excel file with formatted sheets Read ExcelSheet Names XLS Formatting XLS ControlTable Generator Rule Engine XLS ControlTable Generator Table Row ToVariable Loop Start Excel Reader Loop End Merge Ports XLS Formatter(apply) Modifying multiple sheets with a format pattern in an Excel fileThis workflow iterates over multiple sheets in an Excel file using a loop and uses the control table to tag the "header" and "body" for each sheet that has to be formatted. After the completion of the loop, a PortObject for format pattern is genrated for each sheet which is then megred into one, before it is applied. Reading excel file with multiple sheetsGenerate control tableDefine rules for header and bodyGenerate control table with the tags "header and "body"Iterate over sheetsReading one sheet at a timeCollect XLS formatting for all sheets as PortObjectscopy/pastable componentthat recursively mergesa column's XLS Formatterport objects to oneWrite a new Excel file with formatted sheets Read ExcelSheet Names XLS Formatting XLS ControlTable Generator Rule Engine XLS ControlTable Generator Table Row ToVariable Loop Start Excel Reader Loop End Merge Ports XLS Formatter(apply)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: hannansaleem
Created at: 2022-07-27
On NodePit since: 2022-07-29
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: Workflow SnippetXLSFormattingLoop

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!