# Clear Range (preview)

> Clear Range activity that clears the values of a rectangular cell range in an Apple Numbers table.

`UiPath.AppleNumbers.Activities.ClearRange`

## Description

Clears the values of a rectangular cell range in an Apple Numbers table.

This activity empties the cell values in a range specified in A1 notation, keeping the table structure intact, and returns a snapshot of the table after the operation.

:::note
This package only runs on macOS systems with Apple Numbers installed.
:::

## Project compatibility

Windows | Cross-platform

## Configuration

You can configure the activity and its properties as follows:

* **File (local path)** - The path to the Apple Numbers spreadsheet file.
  + **Use a File Resource** - Switches to a file resource reference instead of a plain path. You can browse for a file in either mode; this only changes how the reference is stored.
  + **Use Local File** - Switches back to the plain path field, restoring your previous value.
* **Sheet** - The name of the sheet containing the table.
* **Range** - The range to clear in A1 notation, for example, `B2:D4`.
  :::note
  For more details on the plus menu options, check [Designing automations](https://docs.uipath.com/studio/standalone/latest/user-guide/designing-automations).
  :::

### Properties panel

#### Input
* **Table name** - The name of the table. Defaults to the first table in the sheet if not specified.

#### Output
* **Table information** - Information about the table after the operation, including sheet name, table name, row count, column count, and header row count.