Read Cell Formula
Description
The Read Cell Formula activity retrieves the formula contained in a worksheet cell.
This activity returns the formula expression stored in the cell rather than the calculated result of the formula.
Common Capabilities
Process Data Support
This activity supports dynamic configuration using variables from the Process Data drawer.
You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.
Learn more → Using Process Data
Design-Time Configuration
Workbook Configuration
This activity requires an Excel workbook.
Learn more → Excel Workbook Configuration
Worksheet Selection
This activity operates on a worksheet within the workbook.
Learn more → Excel Worksheet Selection
Cell Selection
Selects the cell whose formula should be retrieved.
Learn more → Worksheet Data Selection
Cell Address
Cell address of the target cell.
Examples:
A1B5C10
Row Index
Zero-based row index of the target cell.
Used together with Column Index when selecting a cell by position.
Column Index
Zero-based column index of the target cell.
Used together with Row Index when selecting a cell by position.
For example:
| Row Index | Column Index | Cell |
|---|---|---|
| 0 | 0 | A1 |
| 0 | 1 | B1 |
| 1 | 0 | A2 |
Behavior
The activity retrieves the formula stored in the selected cell.
Examples:
| Cell Formula | Returned Value |
|---|---|
=SUM(A1:A10) | =SUM(A1:A10) |
=A1+B1 | =A1+B1 |
=TODAY() | =TODAY() |
If the selected cell does not contain a formula, an empty value is returned.
Outputs
Formula
Returns the formula contained in the selected cell.
Returns an empty value when the cell does not contain a formula.
Wait All Incoming
Controls how this activity behaves when multiple incoming execution paths converge.
Determines whether the activity executes when any incoming path completes, or only after all relevant paths have completed.
Learn more → Execution Control
On Error
Defines how the workflow behaves if this activity encounters a runtime error.
Supported strategies include Fault, Continue, Suspend, and Retry.