Insert Rows

Inserts row to a table in the given workbook.

This activity inserts rows at a specific position in the user-specified table in the given workbook using the Microsoft Graph Create row API.

Input

• Connection Id: GraphServiceClient Variable Required Specifies the office 365 connection id.

• Table Name: String Argument Required Specifies the name of the table in which the row is to be inserted.

• Workbook: Object Argument Required Specifies the DriveItem 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 Find Files And Folders activity (which is First or Results) directly as input in this property or use the output variable of the Create Workbook 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].

What To Insert

• Empty Rows: Object Argument Specifies the number of empty rows that are to be inserted.

• Row Values: DataTable Variable 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.

The number of columns in the DataTable input in the Row Values property should match the column count in the given table in the user-specified workbook in the Workbook property.

Where To Insert

• 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: Object Argument 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.