Icon

02_​Pretty_​Table

This example workflow is licensed under

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

What is possible with the XLS Formatting concept in 20 nodes? cell, font & border format alternating row colors This example workflow is licensed under the MITLicense. See LICENSE.txt in the workflowdirectory for details.1UnformattedData Table2Unpivotand addcolumn androw numbers3control tablefor data,header, finance14control tablelight/dark rowsborder columnsfirst row freeze13alternatingrow and columnnumbers 0,1,0,...8bold andlargeheader11thick outerborders fordata, header,finance20applychanged formatto input table12autosizecolumn(big font size)6financeformatting7datato filteredtable17dark rows18light rows5columnborders19freezefirst row10headerorange16pivot backto wide tablelayout15remove allhelper columns4pivot backto wide tablelayout9italic producthierarchyExcel Reader (XLS) XLS ControlTable Generator Rule Engine Rule Engine Math Formula(Multi Column) XLS Font Formatter XLS BorderFormatter XLS Formatter(apply) XLS Row andColumn Sizer XLS Cell Formatter XLS SheetProperties XLS BackgroundColorizer XLS BackgroundColorizer XLS BorderFormatter XLS SheetProperties XLS BackgroundColorizer XLS ControlTable Generator Column Filter XLS ControlTable Generator XLS Font Formatter What is possible with the XLS Formatting concept in 20 nodes? cell, font & border format alternating row colors This example workflow is licensed under the MITLicense. See LICENSE.txt in the workflowdirectory for details.1UnformattedData Table2Unpivotand addcolumn androw numbers3control tablefor data,header, finance14control tablelight/dark rowsborder columnsfirst row freeze13alternatingrow and columnnumbers 0,1,0,...8bold andlargeheader11thick outerborders fordata, header,finance20applychanged formatto input table12autosizecolumn(big font size)6financeformatting7datato filteredtable17dark rows18light rows5columnborders19freezefirst row10headerorange16pivot backto wide tablelayout15remove allhelper columns4pivot backto wide tablelayout9italic producthierarchyExcel Reader (XLS) XLS ControlTable Generator Rule Engine Rule Engine Math Formula(Multi Column) XLS Font Formatter XLS BorderFormatter XLS Formatter(apply) XLS Row andColumn Sizer XLS Cell Formatter XLS SheetProperties XLS BackgroundColorizer XLS BackgroundColorizer XLS BorderFormatter XLS SheetProperties XLS BackgroundColorizer XLS ControlTable Generator Column Filter XLS ControlTable Generator XLS Font Formatter

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: 2021-04-01
Last update: 2024-04-18
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!