Add Sheet (preview)

Add Sheet activity that adds a new sheet to an existing Apple Numbers spreadsheet.

UiPath.AppleNumbers.Activities.AddSheet

Description

Adds a new sheet to an existing Apple Numbers spreadsheet.

This activity appends a new sheet to a spreadsheet and returns its actual name. You can specify a name, or leave it empty to use the default name Numbers assigns. You can also choose how to handle a sheet that already has the same name.

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 name - The name for the new sheet. Leave empty to use the default name Numbers assigns, for example, Sheet 2.
  Note:

  For more details on the plus menu options, check Designing automations.

Properties panel

Options

• Conflict resolution - What to do if a sheet with the same name already exists. Doesn't apply if you leave Sheet name empty, since there's no name to check against. Select one of the following options:
  • Overwrite - Deletes the existing sheet and creates a new one.
  • Don't Replace - Throws an exception. This is the default option.
  • Rename - Appends a numeric suffix to create a unique sheet name, for example, My Sheet 2.

Output

• Sheet name - The actual name of the created sheet. It may differ from the requested name when you use the Rename conflict resolution option, or when you leave Sheet name empty and Numbers assigns a default name.