Get formula range
get_formula_rangeRead formulas and computed values from a single cell or rectangular range in a session to check what a cell or block calculates.
Instructions
Read the formulas and computed values of one cell or a rectangular range in a session: the way to check what a cell or a block of cells computes. Pass a single cell ("B4", "Sheet1!B4") or a range ("A1:D10"). Returns {worksheet, range, cell_count, cells: [{cell, formula, value, value_type}]}, with formula including its leading "=" (null for constants and empty cells) and value_type "number", "string", "boolean", "error" or "empty". Read a block in one call rather than cell by cell; to read values by defined name use get_outputs, and for the cells that feed one use trace_dependencies. Every cell in the rectangle is returned, up to 2,000 cells a call; a larger range fails with range_too_large, so read a big block in pieces. An unknown sheet or malformed range fails the call.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A cell or range, e.g. "B4", "A1:D10" or "Sheet1!B2:F2" | |
| session_id | Yes | Session ID returned by create_session (list_sessions shows the open ones) |