Get Rows
Use this action to retrieve the rows from the specified workbook.
Using the Get Rows Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
1. Drag the Get Rows action under the Excel Online connector to the canvas, place the pointer on the action, and then click 
or double-click the action. The Get Rows action window opens.
or double-click the action. The Get Rows action window opens.2. Edit the label name, if needed. By default, the label name is same as the action name.
3. To add an authorization, refer to the section Authorize Excel Online in the Excel Online connector topic.
 | If you previously added an authorization for Excel Online, select an authorization from the list. |
4. In the Folder Name field, select or specify the name of the folder under which the workbook is created.
5. In the Workbook ID field, select or specify the workbook ID to get rows.
6. In the Sheet Name field, select or specify the name of the sheet to get the rows.
7. In the Start field, enter the cell index to start retrieving the data.
8. In the End field, enter the cell index up to which you want to retrieve the data.
9. Click Done.