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.

Prerequisites

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.

Procedure

  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:
    OptionSteps
    Active cell 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.

      Note: This field is not case-sensitive.
    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.
        Note: This field is not case-sensitive.
      • 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.
    The Control Room shows a descriptive default variable name. If you create several output variables, subsequent variable names are appended with a -1, -2, -3, and so on to avoid duplication.
  5. Enter the name of the session used to open the workbook with the Open action.
  6. Click Save.

Next steps

Next, you can insert the string variable containing the cell address into the Specific cell field of actions related to cell operations. See Cell operations in Excel advanced.