get_workbook_metadata
Inspect a workbook's structure before editing: sheets, true used ranges, merged cells, defined names, tables, and edit-risk warnings—read-only while open in Excel.
Instructions
Read a workbook's structure without opening it for edit: every sheet with its visibility state, TRUE used range (value-bearing bounds, not the often wrong stored dimension), dimensions, and merged-cell count, plus defined names, tables, the active sheet, and a round-trip hazard summary (whether an openpyxl edit would drop fragile parts). The orient-before-editing call. Read-only; works while the file is open in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes |