Icon

Demo XLS Control Table Auto Tag Generator

Demo XLS Control Table Auto Tag Generator
Workflow to demonstrate using Continental XLS formatting nodes to format two separate sheets on thesame workbook.This writes the same data to two sheets "Sheet1" and "Sheet2" then applies different formatting to eachsheet.This also demonstrates the use of the XLS Control Table Auto Tag Generator component to create thenecessary tags so that the formatting can refer to tags for data type, column name and header/body. Viewthe output of the auto tag generator component to see the tags available for each cell.@takbb21 Sepember 2022 Sample Data to be written to both sheet1 and sheet2but then formatted differentlyWrite Excel File (this contains no formattingat this point)Format sheetsAll headers to black backgroundHeaders to whiteforegroundsize 16Body (data)to pale creamconditional format numberst:Number (double)resize colsSelect Sheet1All headers to red backgroundHeaders to whiteforegroundsize 16Select Sheet2resize colsFormat all datesto dd mmm yyyyFormat d:Order Value Numbers to currencyFormat Local Date data typeto dd/mm/yyyyMerge sheet 1 and 2 formattingEven numbered data rows to light greenfreeze panesTable Creator Excel Writer XLS Formatter(apply) XLS BackgroundColorizer XLS Font Formatter XLS BackgroundColorizer XLS ConditionalFormatter XLS Row andColumn Sizer XLS Sheet Selector XLS BackgroundColorizer XLS Font Formatter XLS Sheet Selector XLS Row andColumn Sizer XLS Cell Formatter XLS Cell Formatter XLS Cell Formatter XLS Format Merger Pass-through Pass-through XLS Control TableAuto Tag Generator XLS BackgroundColorizer XLS SheetProperties Workflow to demonstrate using Continental XLS formatting nodes to format two separate sheets on thesame workbook.This writes the same data to two sheets "Sheet1" and "Sheet2" then applies different formatting to eachsheet.This also demonstrates the use of the XLS Control Table Auto Tag Generator component to create thenecessary tags so that the formatting can refer to tags for data type, column name and header/body. Viewthe output of the auto tag generator component to see the tags available for each cell.@takbb21 Sepember 2022 Sample Data to be written to both sheet1 and sheet2but then formatted differentlyWrite Excel File (this contains no formattingat this point)Format sheetsAll headers to black backgroundHeaders to whiteforegroundsize 16Body (data)to pale creamconditional format numberst:Number (double)resize colsSelect Sheet1All headers to red backgroundHeaders to whiteforegroundsize 16Select Sheet2resize colsFormat all datesto dd mmm yyyyFormat d:Order Value Numbers to currencyFormat Local Date data typeto dd/mm/yyyyMerge sheet 1 and 2 formattingEven numbered data rows to light greenfreeze panesTable Creator Excel Writer XLS Formatter(apply) XLS BackgroundColorizer XLS Font Formatter XLS BackgroundColorizer XLS ConditionalFormatter XLS Row andColumn Sizer XLS Sheet Selector XLS BackgroundColorizer XLS Font Formatter XLS Sheet Selector XLS Row andColumn Sizer XLS Cell Formatter XLS Cell Formatter XLS Cell Formatter XLS Format Merger Pass-through Pass-through XLS Control TableAuto Tag Generator XLS BackgroundColorizer XLS SheetProperties

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: BATEB031
Created at: 2022-09-21
On NodePit since: 2022-09-22
Last update: 2024-05-02
Created with KNIME version: v4.6.1
Tags: ContinentalXLSXFormatting

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

Try NodePit Runner!