UiPath.Excel.Activities.ExcelLookUpRange

Searches in a specified range for the coordinates of a cell with a certain value and returns them as String variables.

Properties

Common

• DisplayName - The display name of the activity.

Input

• Range - The range where you want to perform the search. This field supports only strings and String variables.
• SheetName - The name of the sheet in the workbook where the change must be made. This field supports only strings and String variables.
• Value - The value that you want to search for. This field supports only strings and String variables.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output

• Result - The cell where the specified value is found. This field supports only strings and String variables.

Example of Using the LookUp Range Activity

To exemplify how to use this activity, we have built an automation project that searches for values in a workbook and logs the found values to the console.
 
 
Download example