# 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.**


---

# 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:

```
GET https://docs.visualyze.ai/integrations/office-365/activities/excel/clear-range.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.