read_data
Read data from an Excel range or retrieve a sheet summary. Optionally fetch detailed cell information, formulas, and formatting, or read all sheets in one call.
Instructions
Read data from an Excel range. When cell_range is omitted, returns a sheet summary (used range address, total rows/columns, headers) WITHOUT reading all data -- call again with a specific cell_range to fetch the actual data. Set detail=True on a single cell to get formula, type, and formatting info. Use sheet="*" to batch-read all sheets in one call.
Args: workbook: Workbook name or path. Defaults to active workbook. sheet: Sheet name. Defaults to active sheet. Use '*' to read all sheets. cell_range: Range like 'A1:D10' or cell like 'B5'. Returns sheet summary if omitted. headers: Treat first row as column headers. detail: For single cells, include formula, type, number format, and font info. merge_info: Fill merged cells with the merge area's value instead of null. header_row: 1-based row number to use as headers (e.g. 3 means row 3 is headers).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workbook | No | ||
| sheet | No | ||
| cell_range | No | ||
| headers | No | ||
| detail | No | ||
| merge_info | No | ||
| header_row | No |