Delete Column (preview)

Delete Column activity that deletes or clears a column in an Apple Numbers table.

UiPath.AppleNumbers.Activities.DeleteColumn

Description

Deletes or clears a column in an Apple Numbers table.

This activity removes or empties a single column in a table, specified by its column letter, 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.
• Column - The column letter to delete, for example, B or AC.
  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 column. Select one of the following options:
  • Delete - Removes the column entirely, shifting remaining columns left. This is the default option.
  • Clear - Empties the cell values but keeps the column 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.