Read Range

UiPath.AppleNumbers.Activities.ReadRange

Reads data from a specified range in an Apple Numbers spreadsheet.

This activity reads a range of cells from an Apple Numbers spreadsheet and returns the data as a DataTable. You can specify a cell range in A1 notation, for example, A1:C10 or read the entire table. The activity supports headers, allowing the first row to be treated as column names in the resulting DataTable.

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 to read from.
  • Use a File Resource - You can select this option to change the current field to File so you can browse for the file location.
  • Use Local File - Select this option to switch back to the initial field. This option is visible only when the File field is also present, which happens after you select the previous option Use a File Resource.
• Sheet - The name of the sheet to read from, for example, Sheet1.
• Cell range - The cell range to read in A1 notation, for example, A1:C3. If you do not specify this, the activity reads the entire table.
  note

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

Properties

Input

• Table name - The name of the table to read from, for example, Table 1.

Options

• Has Headers - The activity also extracts the column headers from the specified spreadsheet range. The first row is treated as table headers. Select True or False. By default, this option is set to True.

Output

• Result - The data table which contains the read range data.