Read column action in Microsoft 365 Excel

Use the Read column action in the Microsoft 365 Excel package to extract data from a column and store it in a List variable.

Settings

  • Enter the name of the session used to open the workbook with the Open action.
  • Select the cell option as Active cell or Specific cell to specify the starting point.
  • You can also select the Read full column option to extract data for the entire column.
  • Assign the output value to a List variable.