Get table column action in Microsoft 365 Excel

Use the Get table column action in the Microsoft 365 Excel package to retrieve the column values of a specified table and column index, and assign the values to a List variable.

Settings

  • Enter the name of the session used to open the workbook with the Open action.
  • Enter the table name.
  • Enter the column index. For example, enter 5 to indicate the fifth column from the left.
  • Select a List variable to store the values.