Defined names
xlide_manage_nameList, add, or remove Excel workbook defined names to simplify formulas and VBA references. Specify file path and name details.
Instructions
Lists, adds or removes a workbook's defined names. A defined name is what lets a formula say TaxRate rather than Config!$B$7, and VBA reads them too, so removing one can break code as well as formulas. action='list' changes nothing. For a range, qualify refers_to with its sheet and use absolute addresses to avoid following the active sheet or moving with a copied formula, for example Data!$A$1:$A$50.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"file_path": "<file_path>"
},
"name": "xlide_manage_name"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | For add and remove: the defined name. | |
| scope | No | A sheet name to scope it to that sheet. Empty means the workbook. | |
| action | No | list, add or remove. | list |
| offset | No | For list: names to skip. | |
| file_path | Yes | Absolute path to the Excel file. | |
| refers_to | No | For add: what it points at, such as Data!$A$1:$A$50. | |
| max_results | No | For list: most names to return. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||