Leggi e rivedi la documentazione di Automation Anywhere

Automation 360

Chiudi contenuti

Contenuti

Apri contenuti

Using the Get cell address action

  • Aggiornato: 2021/02/18
    • Automation 360 v.x
    • Crea
    • Spazio di lavoro RPA

Using the Get cell address action

Use the Get cell address action to retrieve the location of the active cell and store it to a string variable. This action supports .xlsx and .xlxm files.

Prerequisiti

Open a worksheet using the Open action. You must select the Contains header option when configuring the Open action in order to use this action to retrieve the cell address based on the column title name.

Procedura

  1. Double-click or drag the Get cell address action from the Excel advanced node in the Actions palette.
  2. Select whether to retrieve the cell address from the Active cell or Based on header:
    OpzioneFasi
    Cella attiva If you select this option, the bot will retrieve the cell address of the currently active cell. Skip to Step 5.
    Based on header If you select this option, the bot will retrieve the cell address of the cell specified by the column title name and cell position. Complete the following fields:
    1. Enter the column title: If you selected the Sheet contains header option when you opened this sheet using the Open action, enter the column name. For example, First Name.

      If you did not select that option, enter the default column name. For example, A.

      Nota: Questo campo non è sensibile alla distinzione tra maiuscole/minuscole.
    2. Enter cell position from column title: Enter the number of cells between the header cell and the cell from which you want to retrieve the address. Enter up to three digits.

      For example, if the header cell is located at B1 and you specify 2 as the cell position, the action will return B3.

  3. Select whether to retrieve the cell address from the Active cell or a Specific cell.
    • If you have selected the Active cell option, the bot will retrieve the cell address of the currently active cell. Skip to Step 5.
    • If you have selected the Specific cell option, the bot will retrieve the cell address of the cell specified by the column title name and cell position. Complete the following fields:
      • Enter the column title: Enter the column name. For example, Name.
        Nota: Questo campo non è sensibile alla distinzione tra maiuscole/minuscole.
      • Enter cell position from column title: Enter the number of cells between the header cell and the cell from which you want to retrieve the address. Enter up to three digits.

        For example, if the header cell is located at B1 and you specify 2 as the cell position, the action will return B3.

  4. In the Save active or user specified cell address in local variable field, create or insert an existing string variable.
    La Control Room mostra un nome descrittivo predefinito della variabile. Se si creano diverse variabili di output, ai nomi delle variabili successive vengono aggiunti -1, -2, -3 e così via per evitare duplicazioni.
  5. Inserite il nome della sessione utilizzata per aprire la cartella di lavoro con il comando Apriaction.
  6. Fai clic su Salva.

Fasi successive

Next, you can insert the string variable containing the cell address into the Specific cell field of actions related to cell operations. Consulta Cell operations.
Invia feedback