Read Column
AutomatR.Excel.Activities.ReadColumn
The "Read Column" activity in AutomatR is part of the Excel activities package, designed to read values from a specified column in an Excel worksheet. This activity facilitates the extraction of columnar data, enhancing automation workflows that involve Excel data manipulation.
Properties
| Name | Description |
|---|---|
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Column Index | Enter the index for the column for which values need to be retrieved. String variables containing the column index. |
| Column Name | Enter the column name for which values need to be retrieved. String variables containing the column name. |
| Delay | Enter the wait time in seconds (Example: 5 seconds, i.e., 5) to start the activity. Integer variables containing the delay duration. |
| Output | |
| OutColumn | Returns the list of strings representing the values of the selected column. List of string variables containing the column values. |
How to use:
- Drag and drop the "Read Column" activity onto the workflow.
- Configure the properties by specifying either the column name or column index for which values should be retrieved.
- Optionally, configure the delay.
- Execute the workflow to read values from the specified column in the Excel worksheet.
Example: Consider an example where the "Read Column" activity is used to read values from the column named "Amount":
Read Column:
Column Name: "Amount"
Delay: 2
OutColumn: AmountValues
In this example, the activity reads values from the "Amount" column with a delay of 2 seconds. The result, representing the values of the "Amount" column, is stored in the list of strings specified in the "OutColumn" property.
Note: Ensure that the "Read Column" activity is placed within an "Excel Root" activity to establish the Excel context for execution. Either the column name or column index must be provided for the activity to function properly.