Skip to content
PlaidCloud

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.

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.

Section titled “Related”