read_range
Read a contiguous cell range from an Excel workbook as a 2D array of values and formulas for risk model analysis.
Instructions
ModelRisk: Read a contiguous range as a 2D array of values and formulas. Use ranges like 'A1:C10'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | ||
| range_ref | Yes | A1-style range like 'A1:C10'. | |
| workbook_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | ||
| errors | No | ||
| values | No | ||
| formulas | No | ||
| workbook | Yes | ||
| range_ref | Yes |