# Read Cell From File

This is a pre-built Action located under the **@Excel Element**. The functionality of this Action in Avo Assure is to read the content from a specific cell in the Excel file. The result of this operation is stored in a dynamic variable for further use during test execution.

## Syntax

**Input Value**: `<Row number>;<Column number>`&#x20;

| Argument                              | Description                                                                              |
| ------------------------------------- | ---------------------------------------------------------------------------------------- |
| <p>\<Row number><br>(Required)</p>    | Provide the row number of the Excel sheet from which you want to read the cell value.    |
| <p>\<Column number><br>(Required)</p> | Provide the column number of the Excel sheet from which you want to read the cell value. |

{% hint style="info" %}
**Note**: When using the **Read Cell from File** action, it can only read values such as text, static values, and column names represented by alphabets from the file.
{% endhint %}

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

| Argument                                 | Description                                                           |
| ---------------------------------------- | --------------------------------------------------------------------- |
| <p>\<Dynamic Variable><br>(Required)</p> | This dynamic variable stores the particular cell value from the file. |
| <p>\<Dynamic Variable><br>(Optional)</p> | This dynamic variable stores the status as **True** or **False**.     |

### Example: Reading Specific Cell Data from an Excel File

In this example, we explain how to read data from a specific cell in an Excel file and store the result for further use.

* **Action**: Read Cell From File
* **Input Value**: 8;4
  * The row number (**8**) specifies the row position in the Excel sheet from which the data needs to be read.
  * The column number (**4**) specifies the column position within the same sheet. Combined with the row number, these coordinates identify the exact cell (Row 8, Column 4) in the Excel file.
* **Output Value**: {Cell Value}
  * The retrieved cell data (e.g., Pending) is stored in the **{Cell Value}** dynamic variable
  * If a second output variable is provided, the action returns the status as True/False:
    * **True**: If the cell data is read successfully.
    * **False**: If the cell data is not read successfully.
* **Logical Explanation**: The **Read Cell From File** action takes the value from the **Input Value** column **8;4** and reads the data from the specified cell in the configured Excel file. The value fetched from that cell is stored in the **{Cell Value}** variable (e.g., Pending).

<figure><img src="/files/iN47ztauHTvBN8Z56yva" 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/read-cell-from-file.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.