read_sheet
Reads Excel sheet cells into a 2D array. Use optional A1 range or row limit to fetch specific portions of the data.
Instructions
Read cell values from a sheet as a 2D array, addressed absolutely from A1.
Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: Optional A1-style range (e.g. "B2:F20"). Omit to read the full used area. max_rows: Optional cap on the number of rows returned, to bound response size for large sheets.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | ||
| sheet | Yes | ||
| max_rows | No | ||
| cell_range | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||