Get Cell Format (preview)

Get Cell Format activity that reads the formatting of a single cell in an Apple Numbers spreadsheet.

UiPath.AppleNumbers.Activities.GetCellFormat

Description

Reads the formatting of a single cell in an Apple Numbers spreadsheet.

This activity returns a CellFormat object describing the formatting of a single cell, including font name, font size, text color, background color, horizontal and vertical alignment, text wrapping, and number format. You can feed this object into the Set Range Format activity to reuse the same formatting elsewhere.

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 target table, for example, Sheet1.
• Cell - The cell address in A1 notation, for example, B3.
  Note:

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

Properties panel

Input

• Table name - The name of the table to read from. Omit to target the first table on the sheet.

Output

• Cell format - A CellFormat object containing the cell's formatting properties.