inspect
Inspect detailed per-cell information including value, formula, number format, style, and hyperlink.
Returns up to 20 cells per call. When the range is larger, the response is truncated and includes nextOffset — call again with the same reference and offset: <nextOffset> to continue.
Examples:
- Single cell: { “reference”: “A1” }
- Range: { “reference”: “B2:C5” }
- Cross-sheet: { “reference”: “Sheet2!A1” }
- Next page: { “reference”: “A1:K10”, “offset”: 20 }
| Parameter | Type | Description | |
|---|---|---|---|
reference | string | required | Cell reference or range to inspect (e.g. ‘A1’, ‘B2:C5’, ‘Sheet2!A1’) |
offset | integer | optional | Pagination offset into the range (0-based, row-major). When the previous response had nextOffset, pass that value here to read the next page. |