Icon

12_​Styling_​Excel_​Tables_​Solution

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

Exercise 12: Formating Excel Tables- Read the table RevenuePerQuarter.table and TagTable.table - Extract the revenue information for 2019 and write it in an excel file.- Use a series of XLS Formatting nodes to assign different formatting operations to the different tags, for example: - Start with the XLS Control Table Generator node - Color the background of the headers yellow using an XLS Background Colorizer node - Color the background of the row headers grey using an XLS Background Colorizer node - Add boarders to all values - Optional resize the columns based on columns headers - Apply the fomatting to the your excel table using the XLS Formatter (apply) node Read revenue per quarterOnly 2019header yellowWrite styled tablerow header greyadd borderResize columnsRead tag tableWrite standard table Table Reader Row Filter XLS BackgroundColorizer XLS ControlTable Generator XLS Formatter(apply) XLS BackgroundColorizer XLS BorderFormatter XLS Row andColumn Sizer Table Reader Excel Writer Exercise 12: Formating Excel Tables- Read the table RevenuePerQuarter.table and TagTable.table - Extract the revenue information for 2019 and write it in an excel file.- Use a series of XLS Formatting nodes to assign different formatting operations to the different tags, for example: - Start with the XLS Control Table Generator node - Color the background of the headers yellow using an XLS Background Colorizer node - Color the background of the row headers grey using an XLS Background Colorizer node - Add boarders to all values - Optional resize the columns based on columns headers - Apply the fomatting to the your excel table using the XLS Formatter (apply) node Read revenue per quarterOnly 2019header yellowWrite styled tablerow header greyadd borderResize columnsRead tag tableWrite standard table Table Reader Row Filter XLS BackgroundColorizer XLS ControlTable Generator XLS Formatter(apply) XLS BackgroundColorizer XLS BorderFormatter XLS Row andColumn Sizer Table Reader Excel Writer

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-11-22
Last update: 2024-05-02
Created with KNIME version: v4.3.0
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!