Read WorkPaper Cell
read_cellRead a cell's calculated value, display text, formula, and serialized content by specifying sheet name and cell address. Verify readback after writing cell contents.
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 |
|---|---|---|---|
| address | Yes | Single A1 cell address such as B3. | |
| sheetName | Yes | Existing sheet name. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| value | Yes | Calculated cell value. | |
| address | Yes | Canonical sheet-qualified A1 address. | |
| formula | Yes | Formula text without losing the original calculated value context, or null for literal cells. | |
| serialized | Yes | Raw serialized cell content; formulas are strings that start with =. | |
| displayValue | Yes | Formatted value as a user would see it. |