Icon

05 Excel Sheets Formatting - Solution

05 Excel Sheets Formatting - Exercise (Solution)

This workflow shows a solution to a hands-on exercise in the L2-DW Introduction to KNIME Analytics Platform for Data Wranglers - Advanced course

Task 1: Create a Tag Table1. Unpivot the Excel table with the XLS Control Table Generator node. Write columnheader to first row.2. Replace the values in the Value column with the following tags:- "header" in the first row- "freeze" in the second row- "risk" in all rows where the travel risk category is 43. Create a tag table with the XLS Control Table Generator node Task 2: Format an Excel Sheet1. Make the header font bold2. Freeze the header row3. Change the cell background to red where the risk category is 44. Change the column widths to 145. Export and inspect the formatted Excel table freeze the header row bold headerredwhere risk = 4autosizecolumn widthReadtravle_advisories.xlsxNode 18XLS ControlTable Generator Rule Engine XLS ControlTable Generator XLS SheetProperties XLS Font Formatter XLS BackgroundColorizer XLS Row andColumn Sizer Excel Reader XLS Formatter(apply) Task 1: Create a Tag Table1. Unpivot the Excel table with the XLS Control Table Generator node. Write columnheader to first row.2. Replace the values in the Value column with the following tags:- "header" in the first row- "freeze" in the second row- "risk" in all rows where the travel risk category is 43. Create a tag table with the XLS Control Table Generator node Task 2: Format an Excel Sheet1. Make the header font bold2. Freeze the header row3. Change the cell background to red where the risk category is 44. Change the column widths to 145. Export and inspect the formatted Excel table freeze the header row bold headerredwhere risk = 4autosizecolumn widthReadtravle_advisories.xlsxNode 18XLS ControlTable Generator Rule Engine XLS ControlTable Generator XLS SheetProperties XLS Font Formatter XLS BackgroundColorizer XLS Row andColumn Sizer Excel Reader XLS Formatter(apply)

Nodes

Extensions

Links