List Named Ranges
list_named_rangesList user-defined named ranges in an Excel workbook, excluding hidden internal names. Provide a workbook name or use the active workbook to get JSON of names and their references.
Instructions
List user-defined named ranges in a workbook.
Hidden/internal names (e.g. Excel's own Print_Area, filter ranges) are omitted.
Args: workbook: Workbook name or path (None = active workbook).
Returns: JSON with each name and what it refers to.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workbook | No |