Read WorkPaper Cell
read_cellRead a cell's calculated value, display text, formula, and serialized content to verify data after editing.
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. |