Output node
Excel Report
Write a styled Excel report with a table, number formats and an optional chart.
What it does
Writes the incoming rows to a new Excel (.xlsx) workbook as a finished report rather than a raw dump. You can style the data as a real Excel table with banded rows and a filter, freeze the header, auto-fit the columns, set a number format per column, and embed a native chart drawn beside the data. The workbook is downloadable from the run.
Inputs and outputs
| Inputs | One. |
| Outputs | None. This node ends a pipeline. |
When to use it
- Produce a polished spreadsheet someone will actually read
- Deliver results people can open, filter and re-chart themselves
- Send a recurring figures pack without formatting it by hand each time
Examples
Styled report
Table style: Striped · Auto-fit: on · Freeze header: on
Banded rows, a filter on every column, and a header that stays put while scrolling.
Money column
Column 'revenue' → Currency ($#,##0.00)
Without a number format Excel shows the raw value, and a date as its serial number.
With a chart
Column chart · Category: month · Values: revenue
A real Excel chart tied to the data range, editable in the workbook.
Name the sheet
Sheet name: Q1 Summary
Beats Sheet1 when the file is going to someone else.
Tips
- Find the file on the run's detail page once the run finishes.
- A Test run leaves you nothing to download; press Run for a real file.
- Excel's own limit is 1,048,576 rows per sheet. Past that the run stops and says so; write CSV or Parquet for machine-sized data.
- A striped table adds banded rows, a filter and a styled header for free, and the chart is a real editable Excel chart that updates if the recipient edits the sheet.
- One sheet per node. Two sheets means two Excel Report nodes, and two files.
- Every number is a real number cell and every date a real date, whatever type the column arrives as, so a SQL Server int or a decimal sums in Excel without the 'number stored as text' warning.
- A long numeric ID can lose its last digits: every number in an Excel cell is a floating-point value, so anything past about 9 quadrillion is rounded. Convert the column to text upstream if it identifies something rather than counting it.
- Rows are written one at a time, so even a full sheet uses little memory. A table style holds the rows on disk until the end first, because Excel needs a table's size before its first row.
- A null is written as an empty cell, not as the word null.