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