Read Cell Formula
AutomatR.Excel.Activities.ReadCellFormula
The "Read Cell Formula" activity in AutomatR is part of the Excel activities package, designed to extract the formula used in a specified Excel cell. This activity enhances automation capabilities by providing access to the formulas within Excel worksheets.
Properties
| Name | Description |
|---|---|
| Input | |
| Cell | Enter the cell number having the cell values with Excel formulas. String variables containing the cell number (e.g., "A1"). |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example 5 seconds, i.e., 5) to start the activity. Integer variables containing the delay duration. |
| Output | |
| Formula | Returns the formula string extracted from the specified Excel cell. String variables containing the cell formula. |
How to use:
- Drag and drop the "Read Cell Formula" activity onto the workflow.
- Configure the properties by specifying the cell number for which you want to extract the formula.
- Optionally, configure the delay.
- Execute the workflow to extract the formula from the specified Excel cell.
Example: Consider an example where the "Read Cell Formula" activity is used to extract the formula from cell "B3":
Read Cell Formula:
Cell: "B3"
Delay: 2
In this example, the activity extracts the formula from cell "B3" with a delay of 2 seconds. The result, representing the cell formula, is stored in the string variable specified in the "Formula" property.
Note: Ensure that the "Read Cell Formula" activity is placed within an "Excel Root" activity to establish the Excel context for execution.