Icon

12_​Styling_​Excel_​Tables

Styling Excel Tables

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 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

Nodes

  • No nodes found

Extensions

  • No modules found

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-16
Last update: 2024-11-18
Created with KNIME version: v4.3.0
Tags: excelcustomizationXLSMicrosoft 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!