Excel Generator
AI-generatedSummary
Generate an Excel (XLSX) file from workflow items with configurable columns, worksheet options, header and cell styling, and conditional row coloring.
Inputs
- fileName (required) — Output file name (supports expressions). Default: report.xlsx
- binaryProperty (required) — Name of the binary property to store the output file in. Default: data
- columnMode — How to define the spreadsheet columns. Auto uses input item keys as headers; Manual requires explicit column definitions.
- columns — Define columns explicitly with header, key, and width (shown only when columnMode is Manual). At least one column required in Manual mode.
- worksheetOptions — Worksheet configuration: sheet name, right-to-left layout, default column width, and workbook creator metadata.
- headerStyle — Styling for the header row: bold, background/fill color, font color, and horizontal/vertical alignment.
- cellStyle — Styling for data cells: alignment, wrap text, and optional thin borders with color.
- enableConditionalStyling — Apply conditional fill colors to rows based on field values.
- styleRules — Style rules evaluated in order; first matching rule applies fill color, font color, and bold formatting to the row.
- fallbackFillColor — Fill color for rows that match no rule. Leave empty for no fill (shown only when enableConditionalStyling is true).
Output shape
Each output item contains json.fileName and binary.[binaryProperty] with the generated XLSX Buffer (MIME type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet).
If continueOnFail is enabled and an error occurs, an output item with json { success: false, error: ... } is returned instead of throwing.
Examples
Example 1: Create a simple Excel report from an items list with auto-detected columns.
Leave columnMode as Auto; all other parameters at defaults.