Skip to main content

LookUp Range

Description​

Searches for the specified string in the given range and returns the list of Cell Address containing the search string.

Properties​

Input​

  • Spreadsheet – Specify the instance of the Excel Workbook.
  • Search String – Specify the value to search for in the specified range.

Misc​

  • DisplayName – Add a display name to your activity.
  • Private – By default, activity will log the values of your properties inside your workflow. If private is selected, then it stops logging.

Optional​

  • Range – Specify the cell range to perform the search. By default, the range is the entire spreadsheet.
  • Sheet Name – Specifies the spreadsheet's name to perform the lookup. By default, it operates on the first spreadsheet.
  • Match Case – Specifies whether to make the search case-sensitive. By default, it is considered false.
  • Match Entire Cell Contents – Specifies whether to match the search string with the entire cell content or match even if the search string was part of the whole text inside the Cell. By default, it is considered false.
  • Continue On Error – It Specifies whether the automation should continue even when the Activity throws an error. If True, the Activity continues without throwing any exceptions. If False, the Activity throws an exception. The default value is False.
    note

    Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

Output​

  • Cell Addresses - Returns the list of Cell addresses that contain the search string.

Example​

Download Example

Correlation Scope