Icon

Excel Formatting- Knime 4.2 x

Excel Formatting- Knime 4.2

Workflow demonstrating some XLS formatting for 10 tabs in Knime 4.2.2.

This intentionally doesn't use iteration, but simply creates a spreadsheet with 10 tabs and then updates the formatting at the end.

The XLS Control Table Auto Generator component used is available from hub (takbb), and provides a convenient means of generating some common tags.

Demo Workflow assumes writing to c:\temp folder.If this doesn't exist, modify the first ExcelWriter node to point at a valid location You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!1st tab3rd tabNth tabNode 24Node 25Node 26Node 27Sheet NNode 39Node 40Node 42Node 43Node 44Node 46Sheet NNode 48You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 50Node 51Node 52Node 53You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Sheet NNode 56Node 57Node 58You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Sheet 12nd tabNode 62Nth tabSheet NNode 65You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 68Node 69Node 70Nth tabSheet NNode 73You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 76Node 77Node 78Nth tabSheet NNode 81You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 84Node 85Node 86Nth tabSheet NNode 89You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 92Node 93Node 94Nth tabSheet 9Node 97You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 100Node 101Node 102Nth tabSheet NNode 105Modify name(this version of KNIMEstill uses Stringsinstead of "Path" variables)You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 108Node 109Node 110Node 112Node 113Node 114 XLS Control Table AutoTag Generator-KNIME4.2 Excel Writer (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Data Generator Data Generator Data Generator Data Generator XLS Sheet Selector XLS Font Formatter XLS BorderFormatter XLS Cell Formatter XLS Formatter(apply) XLS Format Merger XLS Cell Formatter XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 XLS BorderFormatter XLS Cell Formatter XLS Font Formatter XLS BorderFormatter XLS Control Table AutoTag Generator-KNIME4.2 XLS Sheet Selector XLS Cell Formatter XLS Font Formatter XLS BorderFormatter XLS Control Table AutoTag Generator-KNIME4.2 XLS Sheet Selector Excel SheetAppender (XLS) XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter String Manipulation(Variable) XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Format Merger XLS Format Merger XLS BackgroundColorizer XLS BackgroundColorizer Demo Workflow assumes writing to c:\temp folder.If this doesn't exist, modify the first ExcelWriter node to point at a valid location You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!1st tab3rd tabNth tabNode 24Node 25Node 26Node 27Sheet NNode 39Node 40Node 42Node 43Node 44Node 46Sheet NNode 48You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 50Node 51Node 52Node 53You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Sheet NNode 56Node 57Node 58You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Sheet 12nd tabNode 62Nth tabSheet NNode 65You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 68Node 69Node 70Nth tabSheet NNode 73You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 76Node 77Node 78Nth tabSheet NNode 81You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 84Node 85Node 86Nth tabSheet NNode 89You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 92Node 93Node 94Nth tabSheet 9Node 97You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 100Node 101Node 102Nth tabSheet NNode 105Modify name(this version of KNIMEstill uses Stringsinstead of "Path" variables)You would have an XLS Control Generator hereand possibly other nodes to create tagsetc, but I'm lazy!Node 108Node 109Node 110Node 112Node 113Node 114 XLS Control Table AutoTag Generator-KNIME4.2 Excel Writer (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Data Generator Data Generator Data Generator Data Generator XLS Sheet Selector XLS Font Formatter XLS BorderFormatter XLS Cell Formatter XLS Formatter(apply) XLS Format Merger XLS Cell Formatter XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 XLS BorderFormatter XLS Cell Formatter XLS Font Formatter XLS BorderFormatter XLS Control Table AutoTag Generator-KNIME4.2 XLS Sheet Selector XLS Cell Formatter XLS Font Formatter XLS BorderFormatter XLS Control Table AutoTag Generator-KNIME4.2 XLS Sheet Selector Excel SheetAppender (XLS) XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Cell Formatter Excel SheetAppender (XLS) XLS Sheet Selector XLS Font Formatter String Manipulation(Variable) XLS Control Table AutoTag Generator-KNIME4.2 Data Generator XLS BorderFormatter XLS Format Merger XLS Format Merger XLS BackgroundColorizer XLS BackgroundColorizer

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: bbate
Created at: 2022-10-10
On NodePit since: 2022-10-10
Last update: 2024-11-21
Created with KNIME version: v4.2.2

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

Try NodePit Runner!