generate_excel
Generate an Excel workbook (.xlsx) from a structured JSON definition, supporting sheets, columns, rows, formulas, and styling.
Instructions
Generate an Excel workbook (.xlsx) from a structured JSON definition.
The request dict should contain: sheets: List of sheet definitions, each with: name: Sheet tab name columns: Column definitions (header, width, format, align) rows: Data rows (list of dicts with 'values' or 'cells') formulas: List of formula definitions (cell, formula, label) headerFooter: Print header/footer configuration printArea: Print area in A1 notation freezePane: {row, col} for frozen panes headerStyle/dataStyle: Cell styling definitions autoSizeColumns, autoFilter, pageOrientation, fitToPage properties: Document properties (title, author, subject) password: Workbook protection password
Args: request: Structured JSON definition of the Excel workbook.
Returns: Base64-encoded XLSX file.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| request | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |