update-excel-range
Set cell values, formulas, or number format on any Excel range, supporting append, update, and prepend operations without requiring a formal table.
Instructions
Set cell values, formulas, or number format on any range — does NOT require the worksheet to be a formal Excel table. Body: { values: [['v1','v2','v3']] } for a single row, or [['a','b'],['c','d']] for multi-row. Use this for append (target the next empty row's address, e.g. 'A172:H172'), update (target a single cell like 'H42'), or prepend-style edits (read existing, concatenate, write back). Number of inner-array values must match the column count of the address.
💡 TIP: Set cell values, formulas, or number format on any range — does NOT require the worksheet to be a formal Excel table. Body: { values: [['v1','v2','v3']] } for a single row, or [['a','b'],['c','d']] for multi-row. Use this for append (target the next empty row's address, e.g. 'A172:H172'), update (target a single cell like 'H42'), or prepend-style edits (read existing, concatenate, write back). Number of inner-array values must match the column count of the address.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| body | Yes | ||
| driveId | Yes | Path parameter: drive-id | |
| driveItemId | Yes | Path parameter: driveItem-id | |
| workbookWorksheetId | Yes | Path parameter: workbookWorksheet-id | |
| address | Yes | Path parameter: address | |
| includeHeaders | No | Include response headers (including ETag) in the response metadata | |
| excludeResponse | No | Exclude the full response body and only return success or failure indication |