apply_formula
Apply an Excel formula to a specified cell within an open workbook session. Provide session ID, sheet name, cell address, and formula to execute.
Instructions
Apply Excel formula to cell.
Args:
session_id: Session ID from open_workbook (required)
sheet_name: Name of worksheet
cell: Cell address (e.g., "A1")
formula: Excel formula to apply
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": {
"session_id": "<session_id>",
"sheet_name": "<sheet_name>",
"cell": "<cell>",
"formula": "<formula>"
},
"name": "apply_formula"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| session_id | Yes | ||
| sheet_name | Yes | ||
| cell | Yes | ||
| formula | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |