> For the complete documentation index, see [llms.txt](https://docs.avoautomation.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.avoautomation.com/avo-assure/actions/excel/delete-row-in-file.md).

# Delete Row in File

This is a pre-built Action located under the **@Excel Element**. The functionality of this Action in Avo Assure is to delete a specific row in the Excel file based on the row number provided in the **Input Value** column. The result of this operation is stored in a dynamic variable for further use during test execution.

## Syntax

**Input Value**: `<RowNumber>;....;<RowNumber>(Optional)`

| Argument                          | Description                                                                  |
| --------------------------------- | ---------------------------------------------------------------------------- |
| <p>\<RowNumber><br>(Required)</p> | Provide the row number of the Excel file that you wants to delete.           |
| <p>\<RowNumber><br>(Optional)</p> | Provide the multiple row numbers of the Excel file that you wants to delete. |

{% hint style="info" %}
**Note:** You can delete single or multiple rows at a time depending on the input value.
{% endhint %}

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

| Argument                                                    | Description                                                       |
| ----------------------------------------------------------- | ----------------------------------------------------------------- |
| \<Dynamic Variable>(Optional);\<Dynamic Variable>(Optional) | Both dynamic variable stores the status as **True** or **False**. |

### **Example 1: Deleting a Single Row from an Excel File**

In this example, we explain how to delete a specific row from an Excel file using the **Delete Row in File** action.

* **Action**: Delete Row in File
* **Input Value**: 2
  * The row number (**2**) specifies the row position in the Excel sheet that needs to be deleted. This identifies the exact row (Row 2) in the Excel file that will be removed.
* **Output Value**: {Status}
  * The execution status of the action is stored in this **{Status}** variable with the following possible values:
    * **True**: If the row is deleted successfully.
    * **False**: If the row is not deleted successfully.
* **Logical Explanation**: The **Delete Row in File** action takes the value from the **Input Value** column **2** and deletes the specified row (Row 2) from the configured Excel file. The execution status of this operation is stored in the **{Status}** variable as true.

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

### **Example 2: Deleting Multiple Rows from an Excel File**

In this example, we explain how to delete multiple rows from an Excel file using the **Delete Row in File** action.

* **Action**: Delete Row in File
* **Input Value**: 3;4;5
  * Each row number (**3;4;5**) specifies distinct rows in the Excel sheet that need to be deleted. This identifies the exact rows (Row 3, Row 4, and Row 5) in the Excel file that will be removed.
* **Output Value**: {Status}
  * The execution status of the action is stored in this **{Status}** variable with the following possible values:
    * **True**: If the rows is deleted successfully.
    * **False**: If the rows is not deleted successfully.
* **Logical Explanation**: The **Delete Row in File** action takes the value from the **Input Value** column **3;4;5** and deletes the specified rows (Row 3, Row 4, and Row 5) from the configured Excel file. The execution status of this operation is stored in the **{Status}** variable as true.

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


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.avoautomation.com/avo-assure/actions/excel/delete-row-in-file.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.