Create Table

Creates a table in a workbook.

This activity creates a table in a user-specified range in the given workbook using the Microsoft Graph Add table API.

Input

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

• Sheet Name: String Argument Required Specifies the sheet name in which the table is to be created.

• Table Name: String Argument Required Specifies the name of the table that is to be created.

• Range: String Argument Required Specifies the range that represents the data source for creating the table. Input the cell range in A1-style notation like "A1:A5"

• Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook in which the table is to be created. 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 the Find Files And Folders activity then we can directly specify the element in the array. For example : Results[1].

• Add Headers: If set to true, the first row of the user-specified range is used as the header for the table. By default, the value is set to false.