r7_sheet_read
Read spreadsheet values, formulas, and formatting from a worksheet or range in an XLSX file to inspect or extract data for validation.
Instructions
Read spreadsheet values, formulas and formatting from a worksheet or range (e.g. A1:D10).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | No | Range reference (e.g. A1:C10). | |
| filePath | Yes | Path to XLSX file. | |
| sheetName | No | Sheet name (takes precedence over sheetIndex). | |
| sheetIndex | No | 0-based sheet index. | |
| includeStyles | No | Also return normalized formatting for every cell (font, fill, border, alignment, numberFormat) plus merged ranges, row heights and column widths. | |
| includeFormulas | No | Also return the formulas matrix. Use it to verify a formula was written: a formula cell has no cached value until a spreadsheet engine recalculates the workbook. |