Excel Lookup

Activity Description

Finds the contents of a specified selection in an Excel worksheet and returns the coordinates of the first content found in the query.

Property Description

Returns the coordinates

Defines a variable to receive the corresponding coordinate value

Lookup value

Input the text to be searched

Sheet name

By filling in the Excel worksheet name

File Path

Fill in the full path of the Excel file (you can also click on the icon to the right of the input box to select the full path of the file)

Selection coordinates

Enter the coordinates of the area where the content needs to be deleted, the default value is: “A1:A2”, which can be modified according to the actual situation.

Usage Example

Run the result:

Execution steps: Find Excel tables, Sheet1 worksheet in the region of A1: B6 test1 cells - view variable output results

Note: the implementation of activities, the first to close the activities need to use the Excel file