Get column name action

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

Settings

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