read_range
Extract specific cell data from spreadsheet files by defining a rectangular range. Returns values as a structured 2D array with empty cells as null.
Instructions
Read a rectangular range of cells as a list of rows.
Returns a 2D array where each inner list is one row of values. Empty cells return null.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Path to the spreadsheet file | |
| range_str | Yes | Cell range in A1 notation, e.g. 'A1:D10' or '$A$1:$D$10' | |
| sheet | No | Sheet name. Defaults to the first sheet if omitted. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |