Get row number action

The Get row number action in the Excel advanced package enables you to retrieve the row number that contains the specific cell and stores it to a string variable. This action supports .xlsx and .xlxm files.

Settings

This action supports .xlsx and .xlxm files.

  • Select the Active cell or Specific cell option to specify the cell location.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select a string variable from the Save the row number to variable list. 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.