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.
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" }. |