read_spreadsheet
Read spreadsheet data from .xlsx or .csv files. Retrieve headers and rows (up to 200) with optional sheet name and cell range for .xlsx.
Instructions
Read rows and cells from a spreadsheet file (.xlsx or .csv). Returns headers and row data up to max_rows (default 200). For .xlsx files, optionally specify a sheet name and/or cell range (e.g. 'A1:D10'). Requires allow_file_read in ~/.syscontrol/config.json.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to the .xlsx or .csv file (e.g. '~/Desktop/budget.xlsx'). | |
| sheet | No | Sheet name to read (.xlsx only). Defaults to the active sheet. | |
| max_rows | No | Maximum rows to return (1–200, default 200). | |
| cell_range | No | Cell range in A1 notation (e.g. 'A1:D10'). Omit to read all rows. |