get_cells
Fetch multiple specific cells in one read call, returning each value with an honest label (cached, formula, absent, or value) while the workbook remains open.
Instructions
Read many individually addressed cells in one call, the scatter complement to the rectangular read_range. cells is a list of A1 strings or location objects, each resolving to ONE cell (1,000-cell ceiling); values is cached, formula, or both, and every returned value carries the honest label (cached, absent, formula, value), so a formula with no cached value is never passed off as blank. Read-only; works while the file is open in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| cells | Yes | ||
| sheet | No | ||
| values | No | cached |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||