Get outputs
get_outputsRead computed values from an Excel session by defined name, cell, or range to verify formula results after setting inputs.
Instructions
Read computed values from a session by defined name, cell or range: the way to check what a model's formulas return, e.g. after set_inputs. Pass names as defined names, cell refs ("B4", "Sheet1!B4") or ranges ("Sheet1!H2:H18", up to 2,000 cells, one entry per cell); omit names to read every defined name. Returns {values: {: {cell, type, value}}}; a cell holding an Excel error comes back with type "error" and its code, not as a tool failure, while a key that isn't a defined name or valid ref fails the call. Values only: for formula text use get_formula_range, and to see what feeds a value use trace_dependencies.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| names | No | Defined names, cell refs or ranges to read, e.g. ["Revenue", "B4", "Sheet1!H2:H18"] | |
| session_id | Yes | Session ID returned by create_session (list_sessions shows the open ones) |