Find In Range


 

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