Get Row Data

This is a pre-built action in Avo Assure and comes under @Excel element, instructs to Avo Assure 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 sheet and store the result in a dynamic variable.

Syntax

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

Argument	Description
<index/value>	<index/value> - Specifies the mode of row selection: index: Selects the row based on its position in the Excel. value: Selects the row based on the cell value
<row index/cell value>	<row index/cell value> - Specifies the input based on the selected mode: row index: Specify the row index/number of the row you want retrieve. cell value: Provide the specific cell value to retrieve entire row data

Output Value:

Argument	Description
<Dynamic Variable>(Optional)	This variable holds the data that has been retrieved.
<Dynamic Variable>(Optional)	This variable stores the status as true or false

Example 1

Retrieve a complete row data using row index

To fetch data from a specific row in an Excel sheet, the user can use the Get Row Data action. If the data needs to be retrieved based on the row number "2", the input should be in the format index;row number (index;2) and the result is saved in {Row Data} variable and the success status is stored in {Status} variable, with possible values: True – if the row is found and fetched False – if no row is found at the given index

Example 2

Retrieve Row Data by Cell Value

To fetch data from a specific row in an Excel sheet, the user can use the Get Row Data action. If the data needs to be retrieved based on the cell value, the input should be in the format value;data (value;EMP103) and the result is saved in {Row Data} variable and the success status is stored in {Status} variable, with possible values: True – if the row is found and fetched False – if no matching cell value is found