read_range
Reads values, formulas, and number formats from a specified range or entire used range in a live workbook, returning a 2D grid with its address and dimensions.
Instructions
Read values, formulas and number formats from a range of the live workbook. Returns a 2D array (rows x columns) plus the range address and dimensions. Use "usedRange": true to read the whole used range of the sheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | No | A1 range address, e.g. "A1:C10" or "MyTable". Omit when usedRange is true. | |
| sheetName | No | Worksheet name. Defaults to the active worksheet. | |
| usedRange | No | Read the entire used range of the worksheet instead of a specific address. | |
| workbookId | No | Target workbook ID from list_workbooks. Optional when only one workbook is connected. | |
| includeFormulas | No | Include the formulas grid (default true). | |
| includeNumberFormat | No | Include the number-format grid (default false). |