Get Row Data

This is a pre-built action in Avo Assure and comes under @Excel element. This action instructs the Avo Assure Client to fetch an entire row of data and iterate through each cell to retrieve the values. Users can fetch row data based on the index or an existing value in the Excel file and store the result in an output variable.

Syntax

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

Argument	Description
index/value	Requited index/ value
row index/cell value	Requited row index/ cell value

Output: <Dynamic Variable>(Optional)

Example:

A supermarket maintains an inventory Excel file with columns like Item Code, Name, Category, and Stock Quantity. To check the stock of a specific item, the Get Row Data Action is used. For example, if "ITM202" is given as the Item Code, the keyword retrieves the corresponding row and iterate through each cell one by one and stores output in a variable for inventory management.