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.

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.