Read Row
AutomatR.DefaultActivities.WorkBook.ReadRow
The "Read Row" activity in AutomatR is part of the WorkBook activities package, allowing users to read the values of an entire row in an Excel spreadsheet. This activity is useful for extracting data from specific rows in Excel for further processing in your workflow.
Properties
| Name | Description |
|---|---|
| Input | |
| Excel File Path | Specifies the full path of the Excel workbook on the local drive, including the filename (e.g., "C:\excelActivities\workbook.xlsx"). String variables containing the file path. |
| Password | Specifies the password for the workbook if required. Object variables containing the password. |
| Row Index | Specifies the index of the row to be read. Enter the row index as a string. For example, "1" for the first row. String variables containing the row index. |
| Sheet Name | Specifies the name of the spreadsheet from which to read the row. String variables containing the sheet name. |
| Misc | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Read Row" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the delay is 5 seconds, enter "5". |
| Output | |
| Result | Outputs the values of the selected row as a list of strings. Variables of type List<string> to store the values of the row. |
How to Use
- Drag and drop the "Read Row" activity onto the workflow.
- Configure the properties by specifying the Excel file path, sheet name, and row index.
- Optionally, configure the delay.
- Execute the workflow to read the values of the specified row in the Excel spreadsheet.
Example
Consider an example where the "Read Row" activity is used to read the values of the third row from an Excel sheet named "DataSheet" in a workbook located at "C:\excelActivities\workbook.xlsx":
Read Row:
Excel File Path: "C:\excelActivities\workbook.xlsx"
Sheet Name: "DataSheet"
Row Index: "3"
Result: rowValues
In this example, the activity reads the values of the third row from the "DataSheet" and stores them in the List<string> variable "rowValues" for further processing in the workflow.