Activities
latest
false
Banner background image
Productivity Activities
Last updated Mar 13, 2024

LookUp Range

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.

  • Properties
  • Example of Using the LookUp Range Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.