Get Row and Column

This is a pre-built action in Avo Assure and comes under @Excel element. This action allows the user to retrieve the row or column containing a specified value from an Excel sheet, making it easier to locate and work with specific data within the file and save the result in dynamic variable.

Syntax

Input Value: <text>

Argument	Description
text (Required)	Required text for retrieve the row or column contain

Output Value:

Argument	Description
<Dynamic Variable> (Optional)	This variable holds the row/column data
<Dynamic Variable> (Optional)	This variable holds the results in True and False

Example

Finds specified text in Excel and returns its cell position with status. The Get Row and Column action takes the value from the Input Value column (for example, "EMP102") and searches the Excel file for the specified text. It returns the row and column location where the text is found. The result is stored in the {RowCol} variable, while the execution status is stored in the {Status} variable, with the following possible values:

• True – if the text is found and position is returned.

• False – if the text is not found.