Insert Rows
Inserts row to a table in the given workbook.
Last updated
Inserts row to a table in the given workbook.
Last updated
This activity inserts rows at a specific position in the user-specified table in the given workbook using the Microsoft Graph API.
Connection Id: Required
Specifies the office 365 connection id.
Table Name: Required
Specifies the name of the table in which the row is to be inserted.
Workbook: Required
Specifies the of the Excel workbook that contains the table in which the specified row is to be inserted. We can also specify the output variable of the activity (which is First or Results) directly as input in this property or use the output variable of the activity (Workbook). If we are using the Results property of Find Files And Folders activity then we can directly specify the element in the array.
For example : Results[1].
Empty Rows: Specifies the number of empty rows that are to be inserted.
Row Values: Required
Specifies the rows of data that are to be inserted in the given table in the workbook. The input should be provided as a DataTable containing rows of data.
Insert Position: Specifies the position at which the rows are to be inserted in the table. The available options are:
Start
End
Specific Index
By default, the value is set to Start.
Specific Index: Specifies the row number in the given table after which the rows are to be inserted. This property is taken into consideration only when the Insert Position is set to Specific Index.