Get row number action in Microsoft 365 Excel

The Get row number action in Microsoft 365 Excel package enables you to retrieve the corresponding row that contains the cell that you specify in a Microsoft 365 Excel workbook and store the value in a variable as a string.

Settings

  • Enter the name of the session used to open the workbook with the Open action.

    See Using the Open action.

  • Use the Cell action field to select one of the following options:
    • Active cell- To retrieve the row number of the currently active cell position and store this output as a string variable
    • Specific cell- To specify a cell by entering the value in the Cell address field.

      Optionally, click the Insert a value icon to select an existing variable that contains the address of the cell for which you want to retrieve the row number.

      Consider the following scenario where you want to retrieve the row number for Sheets from the following workbook:

      Sample workbook

      Enter A3 in the Cell address field. The row number will then be returned as A.

  • Click the Save the row number into local variable drop-down menu to select an existing variable to store the output.

    Click the Create variable icon if you do not have an existing string type variable to store the output.

  • Click Save.