# Delete Rows (preview)

> Delete Rows activity that deletes or clears rows in an Apple Numbers table.

`UiPath.AppleNumbers.Activities.DeleteRows`

## Description

Deletes or clears rows in an Apple Numbers table.

This activity removes or empties one or more rows in a table, specified by index or range, 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.
* **Rows** - 1-based row indices or ranges to delete, separated by commas. Row 1 is always the table's first row, including a header row if present. Supports single indices, for example, `2`, and ranges, for example, `3-5`. Example: `1,3-5,10`.
  :::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.

#### Options
* **Delete mode** - How to handle the specified rows. Select one of the following options:
  + **Delete** - Removes the rows entirely, shifting remaining rows up. This is the default option.
  + **Clear** - Empties the cell values but keeps the row structure intact.

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