> For the complete documentation index, see [llms.txt](https://docs.visualyze.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.visualyze.ai/integrations/office-365/activities/excel/clear-range.md).

# Clear Range

This activity clears values, formats, borders, etc of a given range from a user-specified excel worksheet by using the Microsoft Graph [Clear range](https://docs.microsoft.com/en-us/graph/api/range-clear?view=graph-rest-1.0\&tabs=http) API.

### Input

* **Connection Id:** [`GraphServiceClient Variable`](/getting-started/rpa-studio/variables.md#graphserviceclient) <mark style="color:red;">`Required`</mark>\
  Specifies the office 365 connection id.
* **Sheet Name:** [`String Argument`](/getting-started/rpa-studio/arguments.md#string)  <mark style="color:red;">`Required`</mark>\
  Specifies the name of the sheet from which the data is to be cleared.
* **Range:** [`String Argument`](/getting-started/rpa-studio/arguments.md#string)\
  Specifies the range of cells that are to be cleared. Input the cell range in A1-style notation like "A1:A5".
* **Workbook:** [`Object Argument`](/getting-started/rpa-studio/arguments.md#types-of-arguments)  <mark style="color:red;">`Required`</mark>\
  Specifies the [DriveItem ](https://docs.microsoft.com/en-us/graph/api/resources/driveitem?view=graph-rest-1.0)of the Excel workbook whose data are to be modified. We can also specify the output variable of the [Find Files And Folders](/integrations/office-365/activities/files/find-files-and-folders.md) activity (which is **First** or **Results**) directly as input in this property or use the output variable of the [Create Workbook](/integrations/office-365/activities/excel/create-workbook.md) activity (**Workbook**). If we are using the **Results** property of the **Find Files And Folders** activity then we can directly specify the element in the array.\
  For example : Results\[1].
* **Clear Action:**\
  Specifies the clear action that is to be performed. The available options are:

  * **All**
  * **Formats**
  * **Contents**

  By default, the value is set to **All.**