Microsoft Excel - Get table rows

Use the Microsoft Excel - Get table rows action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to retrieve rows 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 rows 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 rows from.

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

Section

Field

Description

Variable types
(unlabeled)

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Microsoft Excel connection to use to retrieve rows 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 rows 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 rows 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
 

Row index

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

Decimal, Integer
 

Collection rows

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

Decimal, Integer
Output

Rows

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

  • Index: (Integer) The value of the row number retrieved.
  • Row data: (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