read_range
Retrieves values and formulas from a specified range in an Excel workbook as a 2D array, enabling access to data for risk modeling and 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 |