get_workbook_metadata
Fetch workbook metadata like sheet names, active sheet, dimensions, and named ranges from an Excel file. Quickly inspect structure without modifying the file.
Instructions
Return workbook metadata including sheet names, active sheet, dimensions, and named ranges.
Args: file_path: Path to the workbook to inspect.
Returns: WorkbookMetadata: Pydantic model containing sheet list, active sheet, named ranges, and other metadata.
Notes: - Read-only operation. Underlying implementation may use a lightweight reader for speed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheets | Yes | Dimensional info for each sheet. | |
| file_path | Yes | Absolute path to the workbook file. | |
| active_sheet | Yes | Name of the currently active sheet. | |
| named_ranges | Yes | Named ranges defined in the workbook. |