Describe workbook
describe_workbookList a workbook's sheets, used ranges, defined names, and whether it contains macros to understand its structure before reading or editing it.
Instructions
List a workbook's sheets with their used ranges, plus its defined names.
Start here to learn a workbook's structure before reading or editing it.
has_vba tells whether the workbook contains macros, which read_vba can show.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to an .xlsx, .xlsm, .xltx or .xltm file. Relative paths are resolved in the server's workbook directory when one is configured; otherwise use an absolute path. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| sheets | Yes | ||
| has_vba | Yes | ||
| size_bytes | Yes | ||
| defined_names | Yes |