Copy Range

Copies a specific range values from a source to destination workbook.

This activity copies a user-specified range of values from a given source workbook to a 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 the property is left blank then the Source worksheet is taken by default.

• Destination Range: String Argument Required Specifies the range of cells where the copied data are to be pasted. Input the cell range in A1-style notation like "A1:A5".

• Destination Workbook: Object Argument 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 Range: String Argument Required Specifies the range of cells that are to be copied. Input the cell range in A1-style notation like "A1:A5".

• 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].

Options

• What To Copy: Specifies how the surrounding cells should respond when a user-specified cell range is deleted. The available options are:

  • None

  • Up

  • Left

  By default the value is None.