Icon

Write Value to Single Excel Cell

Demo - Write Simple Values to Single Excel Cell

Simplified demo of Write Excel Cell Formula component.

This writes the value of a flow variable containing a calculated total into cell E2, and a label/title in cell F2

write itemcost variable to cell E2 onc:\temp\takbb-demo-products.xlsxdemo dataTry adding some extra rows tocheck the Excel Writer isn't cheatingwrites the demodata to the excel spreadsheetat this point, the excel is a table with just the data from the input portCost for itemsCalculate Sumsum -> variablewrite a label to to cell F2 onc:\temp\takbb-demo-products.xlsxWrite ExcelCell Formula Table Creator Excel Writer Math Formula GroupBy Table Rowto Variable Write ExcelCell Formula write itemcost variable to cell E2 onc:\temp\takbb-demo-products.xlsxdemo dataTry adding some extra rows tocheck the Excel Writer isn't cheatingwrites the demodata to the excel spreadsheetat this point, the excel is a table with just the data from the input portCost for itemsCalculate Sumsum -> variablewrite a label to to cell F2 onc:\temp\takbb-demo-products.xlsxWrite ExcelCell Formula Table Creator Excel Writer Math Formula GroupBy Table Rowto Variable Write ExcelCell Formula

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: 2023-07-14
On NodePit since: 2023-07-14
Last update: 2024-04-30
Created with KNIME version: v4.7.4

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

Try NodePit Runner!