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