Get column name action in Microsoft 365 Excel

The Get column name action in Microsoft 365 Excel package enables you to retrieve the name of a column that contains the specified cell 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 column name 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 column name.

      Consider the following scenario where you want to retrieve the column name for the cell value 7734 from the following workbook:Sample workbook

      Enter B4 in the Cell address field. The column name is then returned as B.

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