Microsoft Excel - Get table columns

Use the Microsoft Excel - Get table columns action to retrieve columns from a table in a workbook.

For more information about the Microsoft Excel connector, go to Microsoft Excel.

Before you begin: 

Jump to:

Configure the Microsoft Excel - Get table columns action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

  2. Select a Connection. If you do not have a connection, see Add a connection.
  1. Select the Workbook the table belongs to.
  2. Select the Table you want to retrieve table columns from.

Microsoft Excel - Get table columns action fields, buttons, and settings

Section

Field

Description

Variable types
(unlabeled)

Connection

The Microsoft Excel connection to use to retrieve columns from a table in a workbook.

To refresh the available connections, click Refresh.

(n/a)
 

Workbook

The workbook containing the table you want to retrieve the columns from. When you specify the Microsoft Excel connection, all the workbooks in the selected connection are available to select from in the drop-down list. When using a variable, use the workbook ID.

Text, Decimal, Integer, Boolean, DateTime, Collection
 

Table

The table you want to retrieve the columns from. When you specify the Workbook, all the tables in the selected workbook are available to select from in the drop-down list. If you want to select a table that is not in the list, you can insert a variable in the Table field. When using a variable, use the table ID or table name.

Text, Decimal, Integer, Boolean, DateTime, Collection
 

Column index

Position identifying the start for the columns to retrieve. Type the value for the number of columns to skip at the start of the collection. For example, if you type a value of 2, the column collection will start at 3.

Decimal, Integer
 

Column count

Value identifying the number of columns to retrieve. For example, if you use a Column count of 2 and Column index of 2, the collection will start at column 3 and include columns 3 and 4.

Decimal, Integer
Output

Columns

Stores the result of the action as an object with the following variables:

  • Data: (Collection) A collection including the following values:

    • Index: (Integer) The value of the column number retrieved.
    • Column name: (Text) The name for the table column retrieved.
    • Column values: (Collection) The data that was retrieved. The data returned can be of type String, Number, or a Boolean. A cell that contains an error will return the error string.

Object