# Clear Range

> `UiPath.MicrosoftOffice365.Activities.Excel.ClearRange`

`UiPath.MicrosoftOffice365.Activities.Excel.ClearRange`

## Description

Uses the Microsoft Graph [Clear range](https://docs.microsoft.com/en-us/graph/api/range-clear?view=graph-rest-1.0&tabs=http) API to clear values, format, fill, border, etc. of a range from the specified sheet.

### Scopes

This activity requires the following scopes:

* Files.ReadWrite

OR

* Files.ReadWrite.All

OR

* Sites.ReadWrite.All

## Project compatibility

Windows - Legacy | Windows

## Configuration

**Properties**

#### Common

* **DisplayName** - The display name of the activity. This property supports `String` variables and string formatted values.

#### Input

* **Clear Action** - Indicates the type of clear action to perform. Select one of three options: **All**, **Formats**, **Contents**. The default value is **All**.
* **Range** - Indicates the range that will be cleared. This property supports `String` variables and string formatted values.
* **Sheet Name** - The name of the sheet from which the range will be cleared. This property supports `String` variables and string formatted values.
* **Workbook** - The Drive Item of the Excel document. Use the [Find Files And Folders](https://docs.uipath.com/activities/other/latest/productivity/office365-find-files-and-folders) activity to retrieve this Drive Item. This field supports only `DriveItem` variables.

#### Misc

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