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.

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.