Get Columns

Activity Description

Gets the column data in the specified data table variable. You can match by column name and choose the output method to be a column object, column array, or list

Property Description

Output Column Data

Define a variable to receive the fetched column data

Worksheet name

Specifies the worksheet from which the columns are to be fetched

Column name

Match the required columns by the column name.

File Path

Enter the absolute path of the worksheet

Include header

If include table header is checked, then the column people need to enter the corresponding name, if unchecked, then enter the corresponding column index.

Example of using

Running result:

Execution steps: open the specified data table - get the [1] column of the data table - get the array of columns ["账户标识","1220test9","1220test10","1220test11","1220test12","test1"]