# Verify excel Empty

This is a pre-built Action located under the **@Excel Element**. The functionality of this Action in Avo Assure is to check whether an Excel file is empty or blank, allowing you to verify the presence of data before proceeding with further tasks. The result is stored in a dynamic variable for further use during test execution.

### **Syntax**

**Input Value**: `<excel path>`

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td>&#x3C;excel path><br>(Required)</td><td>Provide the path of the Excel file to verify whether the file is empty or blank.</td><td></td></tr></tbody></table>

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

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td>&#x3C;Dynamic Variable>(Optional);&#x3C;Dynamic Variable>(Optional)</td><td>Both dynamic variable stores the status as <strong>True</strong> or <strong>False</strong>.</td><td></td></tr><tr><td>0</td><td>This show the reports 100% pass even if the step is failed.</td><td></td></tr></tbody></table>

### **Example: Verifying if an Excel File is Empty**

In this example, we explain how to check whether a specified Excel file contains any data using the **Verify excel Empty** action.

* **Action**: Verify excel Empty
* **Input Value**: C:\sam\Get.xlsx
  * The input value (**C:\sam\Get.xlsx**) specifies the path of the Excel file that needs to be verified. The action checks whether the file located at this path contains any data or is empty.
* **Output Value**: {IsEmpty}
  * The execution status of the action is stored in this {IsEmpty} variable with the following possible values:
    * **True**: If the Excel file is empty.
    * **False**: If the Excel file contains data.
* **Logical Explanation**: The **Verify Excel Empty** action takes the value from the **Input Value** column **C:\sam\Get.xlsx** and checks if the specified Excel file has any data. The verification result is stored in the **{IsEmpty}** variable as true.

<figure><img src="/files/o83CKjTDn3oSLUbTQRdY" 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/verify-excel-empty.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.
