Add Rows
Use this action to add rows to the specified workbook.
Using the Add 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 Add 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 Add Rows action window opens.
or double-click the action. The Add 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 add rows.
6. In the Sheet ID field, select or specify the sheet ID to add rows.
7. 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 to enter multiple column values.
◦ 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. 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.
8. Click + to view the additional fields:
◦ Additional Fields—Click Add to enter the following details:
▪ Field Name—Select or specify the name of the user interface field for the Excel Online service.
▪ Field Value—The value for the specified user interface field.
Click Add to add multiple additional fields.
9. Click Done.