generate_json
Convert an existing Excel workbook (.xlsx/.xlsm) into JSON to inspect, transform, or archive its structure. Works directly from Python, JavaScript, or any language without requiring .NET runtime.
Instructions
Reads an existing Excel workbook and returns it as JSON. The JSON-side equivalent of generate_xml, for a caller whose tooling speaks JSON rather than XML - same use cases (inspect, transform, or archive a workbook's structure without any F#/C# source, or any .NET runtime at all, on the caller's side) and the same worksheet/workbook-level feature set. Usable directly from Python, JavaScript, or any other language, and a human with no MCP client at all can get the same result via fsopenxmldsl-mcp convert <file> --lang json from a plain shell. Unlike generate_xml, there's no runtime JSON Schema validation built into the core library itself (see generate_json_schema's own doc string for why) - but generate_json_schema still returns the documented shape this produces.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to an existing .xlsx/.xlsm file to convert to JSON. |