Actions9
Create Sheet
AI-generatedSummary
Adds a named worksheet to an existing XLSX workbook, or to a new in-memory workbook when no input XLSX binary is supplied. Optionally applies styling to the new sheet and returns the updated workbook as binary data.
Inputs
- Sheet Name (required) — Name for the new worksheet. The operation errors if this is empty or if a sheet with that name already exists.
- Apply Styling — Defaults to false. When enabled, apply simple style rules or advanced ExcelJS-compatible JSON rules; simple mode can also freeze the header row or estimate column widths.
- Options: Input Binary Field — Binary property containing the workbook to update; defaults to
data. If no input item contains it, a new workbook is created. - Options: Output Binary Field — Binary property for the resulting XLSX file; defaults to
data. - Options: Output File Name — Filename attached to the output binary; defaults to
spreadsheet.xlsx.
Output shape
One item containing the updated workbook in binary data and a JSON success flag.
The output binary property uses the configured output field name. The output JSON copies the first input item's JSON, if present, and adds `success: true. The operation fails if the requested sheet already exists.