named_range
List, create, delete, or update named ranges in Excel workbooks to manage cell references by name.
Instructions
List, create, delete, or update named ranges within a workbook.
Args: action: "list", "create", "delete", or "update". file_path: Workbook path. name: Named range name for create/delete/update. destination: Destination range string for create. scope: "workbook" or sheet-scoped identifier. new_destination: New range for update.
Returns: list[NamedRangeInfo] | str
Notes: - Creating/updating named ranges mutates workbook metadata but typically does not alter cell values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | ||
| scope | No | workbook | |
| action | Yes | ||
| file_path | Yes | ||
| destination | No | ||
| new_destination | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |