graph_update_worksheet_range
Writes cell values into a specified Excel worksheet range using a 2D array whose shape matches the target address, enabling updates to .xlsx workbooks through Microsoft Graph.
Instructions
Write cell values to a worksheet range.
Excel workbook APIs need the Files.ReadWrite permission and only work on .xlsx files.
Args: item_id: The workbook file ID. worksheet: Worksheet ID or name. address: Range address to write (e.g. "A1:D10"). Its shape must match values. values: Cell values as a 2D array, one inner array per row. Cells may be strings, numbers, booleans, or null. drive_id: Drive ID to act on. Empty targets your own OneDrive.
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": {
"item_id": "<item_id>",
"worksheet": "<worksheet>",
"address": "<address>",
"values": "<values>"
},
"name": "graph_update_worksheet_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| values | Yes | ||
| address | Yes | ||
| item_id | Yes | ||
| drive_id | No | ||
| worksheet | Yes |