Add Sheet

Adds a new sheet to the specified workbook.

This activity adds a new worksheet to a user-specified workbook using the Microsoft Graph Add worksheet API. Each new worksheet created by this activity will be added to the end of the existing worksheets in the workbook.

Input

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

• Sheet Name: String Argument Required Specifies the name of the sheet that is to be added.

• Workbook: Object Argument Required Specifies the DriveItem of the Excel Workbook in which the new sheet is to be added. 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].