Export to Excel Sheets
Description
Section titled “Description”Writes several project tables into different sheets of a single Microsoft Excel workbook, preserving the formatting of a styled template. Each table fills one named sheet; the whole workbook is seeded from the template once and rendered in a single pass, so the sheets no longer overwrite one another the way separate single-sheet exports would when they share an output file.
Use this step when one workbook has to carry more than one sheet of results — for example a formatted reporting template with a data sheet, a summary sheet, and a parameters sheet. For a single sheet, or for a plain unstyled workbook, use Export to Excel instead.
The template’s formatting carries through to each written sheet: values, number formats, fonts, fills, borders, merged cells, and column widths. A template that contains pivot tables or charts drops those objects when its sheets are written — they are not reproduced by the write.
Export Parameters
Section titled “Export Parameters”Output File
Section titled “Output File”The document account and folder the workbook is written to, together with the workbook File Name.
Template File
Section titled “Template File”The styled template the workbook is seeded from — a document account and path to
an existing .xlsx file whose formatting every written sheet inherits. When no
template is given, the step seeds from the existing output file if one is
already present.
Compression
Section titled “Compression”The workbook is written uncompressed by default. Zip, GZip, or BZip2 compression is available.
Sheets
Section titled “Sheets”Each entry in the Sheets table fills one worksheet in the workbook:
| Field | Purpose |
|---|---|
| Source | The project table supplying the sheet’s rows. |
| Target Sheet | The sheet in the template to fill. |
| Range | An optional A1-style range (for example A1:S1000000) whose existing values are cleared before the table is written, leaving the surrounding template cells untouched. |
| Write Header | Whether to write the column-name header row. On by default. |
| Columns | The columns to write, in order, when you do not want every column of the source table. |
These fields are also on the form:
- A Workbook That Exists (
if_exists) — Fail the step, writing nothing (fail) stops the step when the workbook already exists. The default, Write the sheets into it (replace), writes it. - On a sheet entry, Order Rows By (
sort_columns) orders the written rows by these source columns, first key first, each with a Column, Ascending and Nulls setting; Missing Cells As (null_as) is the text written in every missing cell of the sheet, numeric columns included; and A Sheet That Exists (if_sheet_exists) decides what happens when the workbook already has the sheet: Fail the step (fail) stops the step and Leave it as it is (skip) leaves that sheet as it is.
Size Limits
Section titled “Size Limits”Each sheet is bound by the same Excel limits as a single-sheet export: at most 1,048,576 rows (the header row counts) and 16,384 columns. A sheet that would exceed them stops the step rather than producing a file Excel refuses to open. For data beyond these sizes, export to CSV or Parquet instead.
Related
Section titled “Related”- Export to Excel — a single sheet, styled template or plain workbook
- Export Templated — render tables through an XML template
- Export steps