r7_sheet_write
Write values, dates, or formulas into an XLSX worksheet by index or name. Address cells via A1 references or full matrices for precise sheet updates.
Instructions
Write values, dates or formulas into an XLSX worksheet, addressed by index or name.
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>"
},
"name": "r7_sheet_write"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cells | No | Individual cell updates: [{ ref, value, formula?, numberFormat?, date? }]. Set date: true (or a date numberFormat) with an ISO 8601 value to store a real date serial instead of text, and numberFormat to apply an Excel number format to the cell. | |
| matrix | No | 2D matrix of values to write. | |
| filePath | Yes | Path to XLSX file. | |
| sheetName | No | Sheet name (takes precedence over sheetIndex). | |
| startCell | No | Starting cell (e.g. A1). | |
| outputPath | No | Optional target path. | |
| sheetIndex | No | 0-based sheet index. |