r7_sheet_formula
Insert or update an Excel formula in a specific XLSX cell, with optional sheet selection, number formatting, and output path.
Instructions
Insert or update a formula in an XLSX spreadsheet cell.
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": {
"filePath": "<filePath>",
"cell": "<cell>",
"formula": "<formula>"
},
"name": "r7_sheet_formula"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | Target cell reference (e.g. D2). | |
| formula | Yes | Excel formula string (e.g. =SUM(A2:C2) or =B2*1.2). | |
| filePath | Yes | Path to XLSX file. | |
| sheetName | No | Sheet name (takes precedence over sheetIndex). | |
| outputPath | No | Optional target path. | |
| sheetIndex | No | 0-based sheet index. | |
| numberFormat | No | Optional number format for the cell, e.g. { type: "currency" }. |