create_excel_workbook
Create a new .xlsx from sheet specs with headers, rows, formulas, freeze panes, number/conditional formats, data validation, and column widths. Saves to output path, overwriting existing file.
Instructions
Create a NEW Excel workbook from typed sheet specs: each sheet carries name, headers, rows, cell formulas, freeze panes, number_format, conditional_format, data_validation, and column widths. Writes a new .xlsx at output_path and overwrites any file already there. For targeted changes to an existing workbook use edit_excel_workbook; for read-only inspection use analyze_excel_data.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheets | Yes | Worksheets to build (in order). | |
| options | No | Tool options. | |
| metadata | No | Optional document properties (title/author/...). | |
| output_path | Yes | Output .xlsx path to create. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||