read_range
Reads cell values, formula text, or both from a specified worksheet range in an .xlsx workbook, returning markdown, CSV, or JSON with date and format notes so agents can inspect sheet data before editing.
Instructions
Read cells from one sheet.
range: A1-style: 'A1:D20', 'B3', 'A:C' (whole columns), '2:9' (whole rows). Omit for the whole used range. Anything beyond the used range is clamped. mode: 'values' (cached results of formulas; constants as stored), 'formulas' (formula text instead of results), or 'both' ('=SUM(A1:A3) -> 6'). format: 'markdown' (default, with row numbers and column letters), 'csv', or 'json'. max_cells: output cap (default 2000, max 20000); when exceeded the reply says which range to request next.
Dates are shown as ISO 8601 and the number format is reported in a note. Formulas are NOT calculated: if the file has no cached values the reply says so instead of showing blanks. Merged ranges in view are listed (the value lives in the top-left cell).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | values | |
| path | Yes | ||
| range | No | ||
| sheet | Yes | ||
| format | No | markdown | |
| max_cells | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |