excel_set_formulas
Set formulas in specific XLSX cells and trigger recalculation when the file opens in Excel.
Instructions
Set formulas in specific XLSX cells and request recalculation when opened in Excel.
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": {
"path": "<path>",
"sheet": "<sheet>",
"formulas": "<formulas>"
},
"name": "excel_set_formulas"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Absolute path or path relative to the server working directory | |
| sheet | Yes | ||
| formulas | Yes | ||
| overwrite | No | ||
| outputPath | No | Optional output path. Omit to update the input file in place. |