Get Row and Column

This is a pre-built Action located under the @Excel Element. The functionality of this Action in Avo Assure is to retrieve the row and column number that contains a specified value from an Excel sheet. The result is stored in a dynamic variable for further use during test execution.

Syntax

Input Value: <text>

Argument	Description
<text> (Required)	Provide the text to retrieve the row number and column number that contain the given value.

Output Value: <Dynamic Variable>;<Dynamic Variable>(Optional)

Argument	Description
<Dynamic Variable> (Required)	This dynamic variable stores the row and column number.
<Dynamic Variable> (Optional)	This dynamic variable stores the status as True or False.

Example: Finding Specified Text and Retrieving its Cell Position

In this example, we explain how to find a specified text in an Excel file and return its cell position using the Get Row and Column action.

• Action: Get Row and Column

• Input Value: Accountant

  • The input value (Accountant) specifies the text to be searched within the Excel sheet. The action searches for this text across the sheet and identifies the exact row and column coordinates where it is located.

• Output Value: {RowCol}

  • The row and column position (e.g., Text 'Accountant' found at row 4, column 3) is stores in the {RowCol} dynamic variable.

  • If a second output variable is defined, it stores the action status with the following possible values:

    • True: If the text is found and the position is returned successfully.

    • False: If the text is not found in the Excel sheet.

• Logical Explanation: The Get Row and Column action takes the value from the Input Value column Accountant and searches the configured Excel file for the specified text. It returns the row and column position where the text is found. The retrieved position is stored in the {RowCol} variable (e.g., Text 'Accountant' found at row 4, column 3).