add_name
Define a named range or formula in a workbook to simplify cell references for calculations and data analysis.
Instructions
Define a named range (named formula) in the workbook, e.g. name "TaxRate" for "=Sheet1!$B$1".
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": {
"name": "<name>",
"ref": "<ref>"
},
"name": "add_name"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ref | Yes | Reference formula, e.g. "=Sheet1!$A$1:$D$10". | |
| name | Yes | Name to define, e.g. "TaxRate". | |
| comment | No | Optional description. | |
| workbookId | No | Target workbook ID from list_workbooks. Optional when only one workbook is connected. |