read_range
Retrieve data from any Excel cell or range using flexible location addressing, with options for cached values, formulas, or both, clearly labeling absent results to avoid misleading blanks.
Instructions
Read a cell or range addressed by a location object (cell, range, r1c1, name, table, used_range, region, search, or a grid-view anchor; sheet picks the sheet when the location does not, default active). values controls the honest calc story: 'cached' returns the last calculated values, 'formula' the formula strings, 'both' pairs each value with a label (cached, absent, formula, value). A formula cell with no cached value is labelled 'absent', never passed off as blank. Read-only; page large ranges with query_range.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| sheet | No | ||
| values | No | cached | |
| location | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||