Read WorkPaper Cell
read_cellRead a single cell's calculated value, display text, formula, and serialized content. Use after setting cell contents to verify readback.
Instructions
Read one cell with calculated value, display text, formula text, and serialized content. Use after set_cell_contents to verify readback.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheetName | Yes | Existing sheet name. | |
| address | Yes | Single A1 cell address such as B3. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| address | Yes | Canonical sheet-qualified A1 address. | |
| value | Yes | Calculated cell value. | |
| serialized | Yes | Raw serialized cell content; formulas are strings that start with =. | |
| formula | Yes | Formula text without losing the original calculated value context, or null for literal cells. | |
| displayValue | Yes | Formatted value as a user would see it. |