xlsx_named_ranges
Extract defined names and their references from a local .xlsx workbook to understand formula context before reading data.
Instructions
list all defined names (named ranges) in a LOCAL .xlsx workbook — name, scope (workbook or sheet), kind (cell / range / formula), reference. pandas.read_excel collapses named ranges into anonymous ranges; this tool surfaces them so the agent can reason about formulas like =NPV(DiscountRate, Cashflows) before reading data.
USE WHEN: the agent is reasoning about a financial / engineering model and needs to know what cells named-range references resolve to. Call before xlsx_read to orient.
DO NOT USE WHEN: the workbook has no formulas (named ranges are mostly relevant for formula contexts). Or for upload/attached files.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_b64 | Yes |