create_workbook_from_json
Creates an Excel workbook from JSON data, supporting styling, tables, and charts, then saves it to the specified path.
Instructions
Builds a new Excel workbook from JSON matching the shape generate_json produces (see the main library repo's Json.schema.json) and saves it to disk - the inverse of generate_json. The JSON-side equivalent of create_workbook_from_xml, for a caller that already produces data as JSON and wants to reach Excel without learning the OOXML schema, this library's own F#/C# API, or needing .NET installed at all - the .NET work happens inside this server, so any language can call it directly, and a human with no MCP client at all can get the same result via fsopenxmldsl-mcp build from a plain shell. Covers the same worksheet/workbook-level feature set generate_json does; unlike create_workbook, this isn't limited to plain cell values - styling, tables, charts, and every other modeled feature can be expressed in the JSON.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| json | Yes | The workbook JSON content - an object matching Json.schema.json's root shape. | |
| path | Yes | Output file path, e.g. "C:\reports\invoice.xlsx". The directory must already exist. |