Excel Data Processing

Read Excel, process data row by row, and save results

Steps

#	Activity	What it does
1	TableImport	Load the input file into a named table on the runner
2	TableQuery	Materialise the rows for iteration
3	CreateTable	Create an in-memory table for the processed rows
4	ForEachLoop	Process each row
5	TableUpsertRow	Write the transformed row into the output table
6	TableExport	Export the processed rows

Workflow

TableImport("input", "./input.xlsx")
inputRows = TableQuery("input")
CreateTable("output", schema={"columns": [{"name": "value"}, {"name": "processed"}]})
for row in inputRows.rows:
    TableUpsertRow("output", {"value": "{{ row.value }}", "processed": "{{ row.value * 2 }}"}, append=True)
TableExport("output", "./output.xlsx", format="xlsx", sheetName="Results")