create_workbook
Creates an Excel workbook from sheets of plain text cells, saving to a specified path. Handles formulas, booleans, numbers, and text automatically.
Instructions
Creates a new Excel workbook (.xlsx) from a simple grid of sheets/rows/cells and saves it to disk. Each cell is given as plain text, the same way you'd type it into Excel: a leading '=' makes it a formula (e.g. "=SUM(A1:A2)"), 'true'/'false' makes a boolean, a bare number is numeric, and anything else is text. Rows don't need to be the same length. Does not support cell styling, tables, charts, or pivot tables in this version - reference the Kookerella.FsOpenXmlDsl library directly for those.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Output file path, e.g. "C:\reports\invoice.xlsx". The directory must already exist. | |
| sheets | Yes | The sheets to create, in order. Each sheet has a Name and a Rows grid (array of rows, each an array of cell text). |