read_workbook
Read any .xlsx or .xlsm file to extract sheets and cell values as JSON. Formulas appear as expressions with cached values, making workbook data accessible for further processing.
Instructions
Reads an existing Excel workbook (.xlsx/.xlsm) and returns its sheets and cell contents as JSON. Formula cells are rendered as "=expression" (matching create_workbook's input convention), with any cached value included separately under CachedValue. Features outside the core cell model (charts, tables, pivot tables, styling, etc.) are not included in this output - see MAPPING.md in the main library repo for the full list of what round-trips.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to an existing .xlsx or .xlsm file. |