# Clear Range Workbook (preview)

> Clear Range Workbook activity that clears the contents, and optionally the formatting, of a range without moving any cells.

`UiPath.Excel.Activities.ClearRange`

## Description

Clears the contents, and optionally the formatting, of a range without moving any cells. This is the cross-platform equivalent of the [Clear Sheet/Range/Table](https://docs.uipath.com/activities/other/latest/productivity/clear-range-x) Windows activity.

:::note
This activity does not support `.xls` files.
:::

## Project compatibility

Windows | Cross-platform

## Properties

### Common

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

### Input

* **File** - The full path of the resource workbook. To switch to a local path, select the plus icon, and then **Use Local File**. The current field changes to **File (local path)**, where you can provide the full path of the workbook.
* **SheetName** - The name of the sheet from the workbook.
* **Range** - The range to clear. This field is required.

### Options

* **Has headers** - Select this option if the first row of the range is a header row. The header row is not cleared. A range that has a single row is left as it is. By default, this option is not selected.
* **Clear Formatting** - Select this option to clear the formatting of the range as well as its contents. By default, this option is selected, as in the Windows activity.
* **Password** - The password of the workbook, if necessary.

### Use Workbook

* **Workbook** - The existing workbook to use instead of a file path.

## Notes

* Cells outside the range are never moved. The activity only clears what is inside the range.
* When **Has headers** is selected, the header row is the first row of the range, or of the used range when you use a whole-column address.
* A whole-column or whole-row range, such as `A:A`, is limited to the used range of the sheet.
* **Range** must refer to the sheet in **SheetName**. A range that includes a sheet name, such as `Sheet2!A1:A10`, is not supported and causes an error.