# 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.

{% hint style="info" %}
**Note**: While retrieving the row data of the specified Excel sheet, Avo Assure considers the header as the first row.
{% endhint %}

## Syntax

**Input Value**: `<index/value>;<row index>/<cell value>`&#x20;

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td>&#x3C;index/value><br>(Required)</td><td><p>Provide the mode of row selection.</p><ul><li><strong>index</strong>: Selects the row based on its position in the Excel sheet.</li><li><strong>value</strong>: Selects the row based on the specified cell value.</li></ul></td><td></td></tr><tr><td>&#x3C;row index/cell value><br>(Required)</td><td><p>Provide the input based on the selected mode.</p><ul><li><strong>row index</strong>: Provide the row index number of the row you want to retrieve (e.g., index;2).</li><li><strong>cell value</strong>: Provide the specific cell value to retrieve the entire row data (e.g., value;demo).</li></ul></td><td></td></tr></tbody></table>

**Output Value**: `<Dynamic Variable>;<Dynamic Variable>(Optional)`&#x20;

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td><p>&#x3C;Dynamic Variable></p><p>(Required)</p></td><td>This dynamic variable stores the retrieved data from the Excel file.</td><td></td></tr><tr><td><p>&#x3C;Dynamic Variable></p><p>(Optional)</p></td><td>This dynamic variable stores the status as <strong>True</strong> or <strong>False</strong>.</td><td></td></tr></tbody></table>

### Example 1: Retrieving Complete Row Data using Row Index&#x20;

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).

<figure><img src="/files/B8AL6lP2AKJ0OrcOZUjr" alt=""><figcaption></figcaption></figure>

### 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).

<figure><img src="/files/6bWvLJjTyAPgR9msMs7p" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.avoautomation.com/avo-assure/actions/excel/get-row-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.