Output XLSX File

2 VersionsOutput

Writes each upstream Analytics.TabularDataset to an .xlsx workbook under output_path, placing the rows on a worksheet named from sheet_name and naming the file from name_template.

How it fits

Typical backends

Spreadsheet export. Assemble computed rows into a tabular dataset and persist them as an Excel workbook for a human reviewer.

JSON-to-spreadsheet. Parse an inbound JSON batch, project it into a table, and emit one workbook per batch.

Caveats

I/O contractEvery cell is written as an inline string, so numbers, dates, and booleans open as text in Excel; columns are labelled by spreadsheet letters derived from position.
FallbackAn empty sheet_name becomes a default sheet, and the characters Excel forbids in a tab name are replaced before the name is truncated to the 31 character limit.
State lifetimeEach call removes any existing file at the target path before writing, so a shared output_path and name_template overwrites earlier workbooks.
State lifetimename_template substitutes a process-local index via {index} or {index:06d}; the counter resets on restart and any other placeholder is left verbatim.

Versions

4ee55f9cdefault
Automated release
8/1/2026