Copy Sheet

Copies specified worksheet from a source to destination workbook.

This activity copies an existing worksheet from the user-specified source workbook and pastes it to a specific worksheet in the destination workbook using the Microsoft Graph Get range, Add worksheet, and Update range APIs.

Input

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

Destination

• Destination Sheet Name: String Argument Specifies the name of the destination sheet to which the copied data are to be pasted. If no value is specified the Source Sheet name is taken by default.

If we use the same workbook for both the Source and Destination workbook properties and the Destination Sheet name is empty, then by default the Source Sheet name is used and a new sheet will be created with a "new" appended to the sheet name ("Sheet1new").

If the specified Source and Destination properties are the same; where the Destination sheet name is the same as an existing worksheet, then instead of creating a new sheet the data in the existing sheet will be overwritten.

• Destination Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook to which the data are to be pasted. 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].

Source

• Source Sheet Name: String Argument Required Specifies the name of the source sheet from which a specific range of data that are to be copied.

• Source Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook whose data are to be copied. 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].