get_cells
Retrieve values and formulas from a rectangular cell range by zero-based sheet, row, and column coordinates; returns non-empty cells with A1 refs and formulas for quick spreadsheet inspection.
Instructions
Read the values (and formulas) in a rectangular range of cells, addressed by zero-based (sheetIdx, startRow, startCol, endRow, endCol). Returns only the non-empty cells, each with its A1 ref, value, and formula (if any). Use this for ordinary "what is in these cells" questions; for a single computed result you can also use build eval_formula. Reads at most 500 cells per call — narrow the range if it is bigger.
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": {
"sheetIdx": "<sheetIdx>",
"startRow": "<startRow>",
"startCol": "<startCol>",
"endRow": "<endRow>",
"endCol": "<endCol>"
},
"name": "get_cells"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| endCol | Yes | Zero-based last column (inclusive). | |
| endRow | Yes | Zero-based last row (inclusive). | |
| sheetIdx | Yes | Zero-based sheet index. | |
| startCol | Yes | Zero-based first column. | |
| startRow | Yes | Zero-based first row. |