Get Row Data

This is a pre-built Action located under the @Excel Element. The functionality of this Action in Avo Assure is to fetch an entire row of data from an Excel sheet by using either the row index or an existing cell value. The result of this operation is stored in a dynamic variable for further use during test execution.

Note: While retrieving the row data of the specified Excel sheet, Avo Assure considers the header as the first row.

Syntax

Input Value: <index/value>;<row index>/<cell value>

Argument	Description
<index/value> (Required)	Provide the mode of row selection. index: Selects the row based on its position in the Excel sheet. value: Selects the row based on the specified cell value.
<row index/cell value> (Required)	Provide the input based on the selected mode. row index: Provide the row index number of the row you want to retrieve (e.g., index;2). cell value: Provide the specific cell value to retrieve the entire row data (e.g., value;demo).

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

Argument	Description
<Dynamic Variable> (Required)	This dynamic variable stores the retrieved data from the Excel file.
<Dynamic Variable> (Optional)	This dynamic variable stores the status as True or False.

Example 1: Retrieving Complete Row Data using Row Index

In this example, we explain how to retrieve the data of a complete row from an Excel file using the Get Row Data action based on a specific row index.

• Action: Get Row Data

• Input Value: index;2

  • The first argument (index) specifies that the data will be retrieved using the row index.

  • The second argument (2) specifies the row number from which the data will be fetched.

• Output Value: {Row Data}

  • The retrieved data (e.g., 1,Roman Reigns,2025-03-15 00:00:00,Shipped) is stores in this {Row Data} dynamic variable.

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

    • True: If the row data retrieved successfully.

    • False: If the row data is not retrieved successfully.

• Logical Explanation: The Get Row Data action takes the value from the Input Value column index;2 and retrieves the complete data from the specified row (Row 2) in the configured Excel file. The fetched data is stored in the {Row Data} variable (e.g., 1,Roman Reigns,2025-03-15 00:00:00,Shipped).

Example 2: Retrieving Row Data using Cell Value

In this example, we explain how to retrieve the data of a specific row from an Excel file using the Get Row Data action based on a given cell value.

• Action: Get Row Data

• Input Value: value;EMP103

  • The first argument (value) specifies that the data will be retrieved using a cell value.

  • The second argument, (EMP103) specifies the cell value to search for in the Excel sheet.

• Output Value: {Row Data}

  • The retrieved data (e.g., EMP103,Bob Johnson,Finance,5500) is stores in this {Row Data} dynamic variable.

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

    • True: If the row data retrieved successfully.

    • False: If the row data is not retrieved successfully.

• Logical Explanation: The Get Row Data action takes the value from the Input Value column value;EMP103 and retrieves the data of the row containing the specified cell value (EMP103) from the configured Excel file. The fetched data is stored in the {Row Data} variable (e.g., EMP103,Bob Johnson,Finance,5500).