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.

Note: This action also supports .csv file format

Syntax

Input: <text>

Argument	Description
text	requited text

Output:

Argument	Description
Dynamic Variable (optinal)	The dynamic variable is optional, as it is used to store the status as either True or False and display it later.

Example 1

The Get Row and Column action retrieves the row and column location of a specific value in a Excel sheet. For example, when searching for Employee ID (EMP102), the action returns the row number as 29 and the column name as Employee ID