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'.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"workbook_name": "<workbook_name>",
"sheet": "<sheet>",
"range_ref": "<range_ref>"
},
"name": "read_range"
}
}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 |