This activity looks for a given text in the excel sheet and returns coordinates (column, row) of the first cell in which the text is located (search by rows). It is required to define the searching scope (top, bottom, right, left). There is a possibility to match whole strings or parts of them.
Required parameters
Parameter type | Parameter name | Description |
Input | WorkbookName | |
Input | WorksheetName | Current activity is performed in the Excel’s worksheet specified here. |
Input | Left | |
Input | Top | |
Input | Right | |
Input | Bottom | |
Input | Retry timeout | |
Input | TextToFind | |
Output | Col | The column number of the found text |
Output | Row | The row number of the found text. |
Optional parameters
Parameter type | Parameter name | Description |
Misc | Alternative Scenario If Failed | |
Misc | DisplayName | |
Misc | Log this activity | |
Output | Result | |
Output | Result Code | |
Output | Result Details |