graph_get_worksheet_range
Read cell values from a worksheet range in an Excel workbook, returning rows of values for a specified address or the used range when no address is given.
Instructions
Read cell values from a worksheet range.
The response values array holds the cell values, one inner array per row.
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 (e.g. "A1:D10"). Empty reads the used range. 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>"
},
"name": "graph_get_worksheet_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| address | No | ||
| item_id | Yes | ||
| drive_id | No | ||
| worksheet | Yes |