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 Only 2019header yellowrow header greyadd borderResize columnsWrite standard tableRead tag tableRead revenue per quarterWrite styled table Row Filter XLS BackgroundColorizer XLS ControlTable Generator XLS BackgroundColorizer XLS BorderFormatter XLS Row andColumn Sizer Excel Writer Table Reader Table Reader XLS Formatter(apply) 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 Only 2019header yellowrow header greyadd borderResize columnsWrite standard tableRead tag tableRead revenue per quarterWrite styled table Row Filter XLS BackgroundColorizer XLS ControlTable Generator XLS BackgroundColorizer XLS BorderFormatter XLS Row andColumn Sizer Excel Writer Table Reader Table Reader XLS Formatter(apply)

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: 2020-04-21
Last update: 2024-04-24
Created with KNIME version: v4.5.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!