Icon

Excel Format Template Components

Excel Format Template Components
Choice of format is based on the current iteration. So alternate iterationsgo via top or bottomThis uses eitherthe XLS Control Format Template 1 componentwhich has black/yellow header and even rows are coloured creamorthe XLS Control Format Template 2 componentwhich has red/blue header and even rows are coloured blueThe XLS Control Format Template components are "pre-canned" formatsusing the continental nodes, and are designed to work wth the XLSControl Table Auot Tag Generator component.You can create your own simply by using one of the available XLS ControlFormat Template components, then "disconnecting" the component fromthe hub, opening it up and adding/modifying the settings in the containedContinental XLS Format components, and then renaming and sharing as acomponent either to your local workspace, or publicly. Store away the formatting fromthis iteration(stores it in a file within theworkflow data folder) Fetch back the stored awayformatting information now thatthe loop has completed Apply the formatting tospreadsheet.This will format 20 tabs Convenience component formodifying the Path (it takes the pathvariable used to write the Excel fileand applies some modifications tothe filename for use with the XLSFormatter (apply) node Component to automaticallygenerate a set of tags whichcan be used by the standardcontinental XLS nodes, andalso by the XLS Control FormatComponents Component to quickly create apath to a new spreadsheet filename contained within localworkflow data area (or otherlocation, as configured) Showcasing some of my components (all available in my public/components area on the hub,as a demonstration of formatting XLSX file after updating in a loop Let's try20 iterationsjust for giggles!define sheet nameCreate some dummy dataWrite Excelwithin the loopComponentquickly define variablesfor xls file pathrelative to localdata folderNode 654sets headings to black/yellowand even rows to creamNode 667Node 670Collect modelfrom current iterationretrieve xls format modelDecide on alternatingformatsbased oncurrentiterationnumberchoose formatfor passing modelsets headings to black/blueand even rows to bluechoose format for passing control tableNode 680Node 681Edit PathVariable Filename Counting Loop Start String Manipulation(Variable) Data Generator Excel Writer Open File or Folder XLS Control TableAuto Tag Generator XLS ControlFormat Template 1 Variable Loop End XLS Formatter(apply) XLS FormatCollector XLS FormatRetriever Math Formula(Variable) CASE Switch Start XLS ControlFormat Template 2 CASE Switch Start CASE Switch End CASE Switch End Choice of format is based on the current iteration. So alternate iterationsgo via top or bottomThis uses eitherthe XLS Control Format Template 1 componentwhich has black/yellow header and even rows are coloured creamorthe XLS Control Format Template 2 componentwhich has red/blue header and even rows are coloured blueThe XLS Control Format Template components are "pre-canned" formatsusing the continental nodes, and are designed to work wth the XLSControl Table Auot Tag Generator component.You can create your own simply by using one of the available XLS ControlFormat Template components, then "disconnecting" the component fromthe hub, opening it up and adding/modifying the settings in the containedContinental XLS Format components, and then renaming and sharing as acomponent either to your local workspace, or publicly. Store away the formatting fromthis iteration(stores it in a file within theworkflow data folder) Fetch back the stored awayformatting information now thatthe loop has completed Apply the formatting tospreadsheet.This will format 20 tabs Convenience component formodifying the Path (it takes the pathvariable used to write the Excel fileand applies some modifications tothe filename for use with the XLSFormatter (apply) node Component to automaticallygenerate a set of tags whichcan be used by the standardcontinental XLS nodes, andalso by the XLS Control FormatComponents Component to quickly create apath to a new spreadsheet filename contained within localworkflow data area (or otherlocation, as configured) Showcasing some of my components (all available in my public/components area on the hub,as a demonstration of formatting XLSX file after updating in a loop Let's try20 iterationsjust for giggles!define sheet nameCreate some dummy dataWrite Excelwithin the loopComponentquickly define variablesfor xls file pathrelative to localdata folderNode 654sets headings to black/yellowand even rows to creamNode 667Node 670Collect modelfrom current iterationretrieve xls format modelDecide on alternatingformatsbased oncurrentiterationnumberchoose formatfor passing modelsets headings to black/blueand even rows to bluechoose format for passing control tableNode 680Node 681Edit PathVariable Filename Counting Loop Start String Manipulation(Variable) Data Generator Excel Writer Open File or Folder XLS Control TableAuto Tag Generator XLS ControlFormat Template 1 Variable Loop End XLS Formatter(apply) XLS FormatCollector XLS FormatRetriever Math Formula(Variable) CASE Switch Start XLS ControlFormat Template 2 CASE Switch Start CASE Switch End CASE Switch End

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-10-09
On NodePit since: 2022-10-10
Last update: 2024-04-27
Created with KNIME version: v4.6.2
Tags: xlsx formatEdit File PathIterate spreadsheet creationXLS Format RetrieverXLS Format CollectorXLS Control Format TemplateXLS Control Table Auto Tag Generator

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

Try NodePit Runner!