Read an explicit cell range
get_cell_rangeRead raw cell values from a specified A1 range in an Excel sheet to handle non-standard layouts without relying on header-row assumptions.
Instructions
Read raw values for an explicit A1 range, e.g. "A1:D20". Use when the sheet has a non-standard layout that the header-row model does not fit. Unlike get_permission_matrix, the range genuinely bounds what Graph transfers.
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": {
"sheet": "<sheet>",
"range": "<range>"
},
"name": "get_cell_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| link | No | SharePoint sharing link (…/:x:/s/Site/TOKEN?e=code) or a direct document URL. Omit if supplying driveId and itemId. | |
| range | Yes | A1-style range, e.g. "A1:D20". | |
| sheet | Yes | Worksheet name. | |
| itemId | No | Item ID from resolve_link. Use with driveId. | |
| driveId | No | Drive ID from resolve_link. Use with itemId. |