generate_excel
Create Excel files from JSON schemas with multiple sheets, charts, formulas, and advanced formatting for reports, dashboards, and data exports.
Instructions
Generate an Excel file from a structured JSON schema.
Use this tool when the user wants to:
Create an Excel file
Export data to Excel
Generate a report/spreadsheet
Download data as .xlsx file
The tool accepts a JSON schema describing the structure, data, and formatting of the Excel file.
Supported features:
Multiple sheets
Custom column widths and formats
Cell styling (fonts, colors, borders, alignment)
Data validation
Conditional formatting
Formulas and totals
Charts and images
Page setup and printing options
Freeze panes, auto-filter
Merged cells
Grouped rows/columns
Sheet protection
Layout types:
table: Simple data table (default)
report: Formatted report with headers and styling
form: Form-style layout
dashboard: Dashboard with charts
calendar: Calendar view
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_name | No | Name of the Excel file (e.g., "report.xlsx") | |
| sheets | Yes | Array of sheet configurations | |
| metadata | No | Workbook metadata | |
| options | No | Output options |