Leer celda

Leer celda actividad que lee datos de una celda especificada en una hoja de cálculo de Apple Numbers.

UiPath.AppleNumbers.Activities.ReadCell

Descripción

Lee los datos de una celda especificada en una hoja de cálculo de 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.

Nota:

Este paquete solo se ejecuta en sistemas macOS con Apple Numbers instalado.

Compatibilidad de proyectos

Windows | Multiplataforma

Configuración

Puedes configurar la actividad y sus propiedades de la siguiente manera:

• Archivo (ruta local) : la ruta al archivo de la hoja de cálculo de Apple Numbers para leer.
  • 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.
  Nota:

  Para obtener más información sobre las opciones del menú más, consulta Diseñar automatizaciones.

Panel de propiedades

Entrada

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

Opciones

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

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

Salida

• Read cell - The value read from the cell.