Get Workbook Metadata
get_workbook_metadataAvoid edit risks by reading a workbook's structure read-only: sheets, visibility, true used ranges, merged cells, names, tables, active sheet, and a round-trip hazard summary.
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 |