Icon

14_​Tag_​Table_​with_​Unequal_​Dimensions

Styling Excel Tables - Solution

Solution to exercise 12 for the KNIME Analytics Platform for Data Wranglers course
- Write data in a Excel file
- Define styling operations on the Excel file (color backgroung, format borders)
- Apply formatting

Excel table has LESS rows and columnsthan the tag table, then empty cells will beformatted Excel table has MORE rows and columnsthan the tag table, then a subset of theExcel table will be formatted Read revenue per quarterOnly 2019header yellowWrite standard tableWrite styled tablerow header greyadd borderResize columnsRead tag tableOnly OnlinestoreResize columnsRead tag tablerow header greyadd borderOnly 2019Write standard tableRead revenue per quarterWrite styled tableheader yellowOnly First 3 columnsTable Reader Row Filter XLS BackgroundColorizer XLS ControlTable Generator Excel Writer (XLS) XLS Formatter(apply) XLS BackgroundColorizer XLS BorderFormatter XLS Row andColumn Sizer Table Reader Column Filter XLS ControlTable Generator XLS Row andColumn Sizer Table Reader XLS BackgroundColorizer XLS BorderFormatter Row Filter Excel Writer (XLS) Table Reader XLS Formatter(apply) XLS BackgroundColorizer Column Filter Excel table has LESS rows and columnsthan the tag table, then empty cells will beformatted Excel table has MORE rows and columnsthan the tag table, then a subset of theExcel table will be formatted Read revenue per quarterOnly 2019header yellowWrite standard tableWrite styled tablerow header greyadd borderResize columnsRead tag tableOnly OnlinestoreResize columnsRead tag tablerow header greyadd borderOnly 2019Write standard tableRead revenue per quarterWrite styled tableheader yellowOnly First 3 columnsTable Reader Row Filter XLS BackgroundColorizer XLS ControlTable Generator Excel Writer (XLS) XLS Formatter(apply) XLS BackgroundColorizer XLS BorderFormatter XLS Row andColumn Sizer Table Reader Column Filter XLS ControlTable Generator XLS Row andColumn Sizer Table Reader XLS BackgroundColorizer XLS BorderFormatter Row Filter Excel Writer (XLS) Table Reader XLS Formatter(apply) XLS BackgroundColorizer Column Filter

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: kathrinmelcher
Created at: 2020-02-18
On NodePit since: 2021-09-17
Last update: 2024-05-03
Created with KNIME version: v4.1.3
Tags: excelcustomizationXSLMicrosoft Exceleducation

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

Try NodePit Runner!