Lire la cellule (Read Cell)

Activité Lire la cellule qui lit les données d’une cellule spécifiée dans une feuille de calcul Apple Numbers.

UiPath.AppleNumbers.Activities.ReadCell

Description

Lit les données d'une cellule spécifiée dans un tableur Apple Numbers.

This activity reads the value from a single cell in an Apple Numbers spreadsheet and converts it to the requested type. You can specify the sheet name, table name, and cell address in A1 notation, for example, A1. The activity supports different cell value types including text, numbers, booleans, and dates. If the cell's value can't be converted to the requested type, the activity throws an exception.

Remarque :

Ce package ne s'exécute que sur les systèmes macOS avec Apple Numbers installés.

Compatibilité du projet

Windows | Multiplate-forme

Configuration

Vous pouvez configurer l’activité et ses propriétés comme suit :

• Fichier (chemin local) : le chemin d’accès au fichier de la feuille de calcul Apple Numbers à partir duquel lire.
  • 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 to read from, for example, Sheet1.
• Cell - The cell to read in A1 notation, for example, A1.
  Remarque :

  Pour de plus amples informations sur les options du menu Plus, consultez la section Conception d'automatisations.

Panneau propriétés

Entrée

• Table name - The name of the table to read from, for example, Table 1. Defaults to the first table in the sheet if not specified.

Options

• Cell value type - The type of value to read from the cell. Select one of the following options:
  • General - Returns the value as its native type — text, a number, a boolean, or a date — matching how the cell is stored in Numbers. This is the default option.
  • Text - Returns the cell value as text.
  • Decimal - Returns the cell value as a decimal number.
  • Number - Returns the cell value as an integer.
  • Boolean - Returns the cell value as a boolean.
  • Date - Returns the cell value as a date, with the time dropped.
  • Time - Returns only the cell's time of day.
  • Date and time - Returns the cell value as a date and time.
  Remarque :

  A boolean cell can also be read as Decimal or Number (1/0), and a number cell can be read as Boolean (any non-zero value is True).

Sortie

• Read cell - The value read from the cell.