Lire la plage (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.

Compatibilité du projet

Windows | Multiplate-forme

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.

Propriétés

Entrée

• 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.

Sortie

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