Icon

01_​XLS_​ControlTables

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 1: XLS Control Table with fix cell range Option 3: XLS Control Table based on dynamic input data and rules Option 2: XLS Control Table based on input table XLS Control Table DefinitionA XLS Control Table serves as a map for the XLS Formatter nodes onwhere to format your XLS sheet. Thus, the column and row namesmust look like in an XLS sheet (see table below). A B C D E 1 head head head head head2 text text text num num3 text text text num num4 t1,t2 t1,t2 t1,t2 num numIn the XLS Formatter nodes you can use the tags defined in yourcontrol table (head, text, num, t1, t2) to change the correspondingcells accordingly. You can also have multiple tags for multipleformatting aspects in the same cell (e.g. t1,t2). Set a tag for a range as in XLS, e.g. A1:B2. Optionally appendor overwrite tag-ranges from previous control tables Directly use an input table's content as control table tags. Unpivot the input table and add columns with row, column and value information of your xlsx-file to definedynamic rules. Apply the XLS Control Table Generator again to pivot back to a wide control table. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.unformatteddata tableinput tableconverted tocontrol tableoverwrite 1st by2nd control tablein case of conflictheader tagrange A1:G1appendfinance tagrange F2:G20unpivotinput tabletag as 'data' and'diagonal' incolumn 'Value'append tagsback to widelayout, conform toXLS Control Tablemanually definedtagsExcel Reader (XLS) XLS ControlTable Generator XLS ControlTable Merger XLS Control Tablefrom Cell Range XLS Control Tablefrom Cell Range XLS ControlTable Generator Rule Engine XLS ControlTable Merger XLS ControlTable Generator Table Creator Option 1: XLS Control Table with fix cell range Option 3: XLS Control Table based on dynamic input data and rules Option 2: XLS Control Table based on input table XLS Control Table DefinitionA XLS Control Table serves as a map for the XLS Formatter nodes onwhere to format your XLS sheet. Thus, the column and row namesmust look like in an XLS sheet (see table below). A B C D E 1 head head head head head2 text text text num num3 text text text num num4 t1,t2 t1,t2 t1,t2 num numIn the XLS Formatter nodes you can use the tags defined in yourcontrol table (head, text, num, t1, t2) to change the correspondingcells accordingly. You can also have multiple tags for multipleformatting aspects in the same cell (e.g. t1,t2). Set a tag for a range as in XLS, e.g. A1:B2. Optionally appendor overwrite tag-ranges from previous control tables Directly use an input table's content as control table tags. Unpivot the input table and add columns with row, column and value information of your xlsx-file to definedynamic rules. Apply the XLS Control Table Generator again to pivot back to a wide control table. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.unformatteddata tableinput tableconverted tocontrol tableoverwrite 1st by2nd control tablein case of conflictheader tagrange A1:G1appendfinance tagrange F2:G20unpivotinput tabletag as 'data' and'diagonal' incolumn 'Value'append tagsback to widelayout, conform toXLS Control Tablemanually definedtagsExcel Reader (XLS) XLS ControlTable Generator XLS ControlTable Merger XLS Control Tablefrom Cell Range XLS Control Tablefrom Cell Range XLS ControlTable Generator Rule Engine XLS ControlTable Merger XLS ControlTable Generator Table Creator

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: user
Created at: 2019-03-12
On NodePit since: 2024-08-08
Last update: 2024-11-17
Created with KNIME version: v4.0.0

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

Try NodePit Runner!