Get Row Data
This action in Avo Assure is available under the @Excel Element. It fetches an entire row of data from an Excel sheet and iterates through each cell to retrieve its values. The row data can be accessed by specifying the row index or by using an existing cell value, and the results are stored in a dynamic variable.
Syntax
Input Value: <index/value>;<row index>/<cell value>
<index/value> (Required)
Specifies 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)
Specifies the input based on the selected mode.
row index: Provide the row index or number of the row to be retrieved. (Example: index;2)
cell value: Provide the specific cell value to retrieve the entire row data. (Example: value;demo)
Output Value:
<Dynamic Variable>
(Optional)
This dynamic variable holds the retrieved data from the file.
<Dynamic Variable>
(Optional)
This dynamic 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 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
Last updated
Was this helpful?