Icon

Write currency data to Excel with Continental Nodes

Node 1@takbb componentgenerate convenience tagsfor use with Contiental nodes@takbb ComponentWrite a new version of the same xlsx butwith formattingIf all doubles are currency, then you could use this and configure the "Doubles" Number formatas $#,##0.00This component does a variety of other "simple" formatting such as coloursBut in this case both the Value and Commissioncolumns are doubles so will both be formattedas currencyWrite an unformattedexcel fileand create path flow variableWrite an unformattedexcel fileand create path flow variableformat the "Value" column, using the tag d:Valueas required currency formatApply continental nodeformattingIn this case only the Value column hasthe currency formattingTable Creator XLS Control TableAuto Tag Generator XLSX Simple Excel FormatApply (branch safe) Excel Writer Excel Writer XLS Cell Formatter XLS Formatter(apply) Node 1@takbb componentgenerate convenience tagsfor use with Contiental nodes@takbb ComponentWrite a new version of the same xlsx butwith formattingIf all doubles are currency, then you could use this and configure the "Doubles" Number formatas $#,##0.00This component does a variety of other "simple" formatting such as coloursBut in this case both the Value and Commissioncolumns are doubles so will both be formattedas currencyWrite an unformattedexcel fileand create path flow variableWrite an unformattedexcel fileand create path flow variableformat the "Value" column, using the tag d:Valueas required currency formatApply continental nodeformattingIn this case only the Value column hasthe currency formattingTable Creator XLS Control TableAuto Tag Generator XLSX Simple Excel FormatApply (branch safe) Excel Writer Excel Writer XLS Cell Formatter 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: BATEB031
Created at: 2024-04-18
On NodePit since: 2024-04-18
Last update: 2024-05-01
Created with KNIME version: v5.2.2

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

Try NodePit Runner!