Update Rows
Use this action to update the rows of the specified workbook.
Using the Update 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 Update 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 Update 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 ID of the workbook to update the rows.
6. In the Sheet ID field, select or specify the sheet ID to update the rows.
7. In the Start field, enter the cell index to update the row.
8. In the End field, enter the end index up to which you want to update the row.
9. In the Select Entry Type field, select the entry type:
Single Row Entry—Specify the column values for a single row.
In the Row Values field, enter the value for the specified Column. Click Add enter multiple columns.
Multiple Row Entries—Specify the row data separated by a comma or a JSON array.
Input Data Type—Select the data type per the input selected.
Row Data—Enter the row data. Enter the row data. If you selected Comma Separated Values as an input data type, provide data in 'Abc,123' format and if you do not want to update cell of row then you need to define 'null,123'. If you selected JSON Array as an input data type, provide data in '[\"Abc\",\"123\"]' format and if you do not want to update cell of row then you need to define '[null,\"123\"]'. Multiple rows can be added by entering multiple CSV lines or by entering an array of JSON array.
10. In the Row Values field, enter the value for the specified Column.
11. Click + to view the Additional Fields, and then click Add to select or specify the details that follow:
Field Name—Name of the Excel Online service field to update.
Value—Value for the specified field.
Click Add to enter multiple additional fields.
12. Click Done.
Was this helpful?