Get Row Data

This is a pre-built located under the @Excel element. It allows Avo Assure to fetch an entire row of data from an Excel sheet and iterate through each cell to retrieve its values. Users can access row data either by specifying the row index or by using an existing cell value, and store the results in a dynamic variable.

Syntax

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

Output Value:

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 using 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