# Clear Sheet/Range/Table

> `UiPath.Excel.Activities.Business.ClearRangeX`

`UiPath.Excel.Activities.Business.ClearRangeX`

Clears the data from a specified sheet, range, or table. The activity can be used with an Excel file selected for a parent [Use Excel File](https://docs.uipath.com/activities/other/latest/productivity/excel-application-card) activity or with the Project Notebook.

## Configuring the activity

#### In the body of the activity

* **Range to clear** - Select **Plus** on the right side of the field, then, from the menu, select the file and then a sheet, table, or range to clear, or select **Indicate in Excel** to indicate a range directly from the file. Alternatively, you can select **Custom Input** to enter the range manually, or **Open in Advanced Editor** to enter a VB expression.
* **Has headers** - If selected, it indicates that the first row in the defined range is a header row and should not be cleared of data. This option is not selected by default.

#### Properties panel

**Common**

* **DisplayName** - The name displayed for the activity in the Designer panel.

**Input**

* **Range to clear** - See **Range to clear** in the body of the activity.

**Misc**

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level.

**Options**

* **Has headers** - See **Has headers** in the body of the activity.