Read Cell
AutomatR.Excel.ReadCell
The "Read Cell" activity in AutomatR is part of the Excel activities package, designed to read the value of a specified Excel cell. This activity enhances automation capabilities by extracting cell information, facilitating data retrieval from Excel worksheets.
Properties
| Name | Description |
|---|---|
| Input | |
| Cell Number | Enter the cell number for which you need to fetch information. 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 | |
| Value | Returns the value of the cell in string format. String variables containing the cell value. |
How to use:
- Drag and drop the "Read Cell" activity onto the workflow.
- Configure the properties by specifying the cell number for which you want to fetch information.
- Optionally, configure the delay.
- Execute the workflow to read the value of the specified Excel cell.
Example: Consider an example where the "Read Cell" activity is used to read the value of cell "B3":
Read Cell:
Cell Number: "B3"
Delay: 2
In this example, the activity reads the value of cell "B3" with a delay of 2 seconds. The result, representing the cell value, is stored in the string variable specified in the "Value" property.
Note: Ensure that the "Read Cell" activity is placed within an "Excel Root" activity to establish the Excel context for execution.