Skip to main content

Copy Range

UiPath.MicrosoftOffice365.Activities.Excel.CopyRange

Description​

Uses the Microsoft Graph Get range, Add worksheet, and Update range APIs to copy a range and pastes it to another location.

Scopes​

This activity requires the following scopes:

  • Files.ReadWrite

OR

  • Files.ReadWrite.All

OR

  • Sites.ReadWrite.All

Project compatibility​

Windows - Legacy | Windows

Configuration​

Properties

Common​

  • DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Destination​

  • Destination Range - Where to paste the copied range. This property supports String variables and string formatted values.
  • Destination Sheet - The name of the destination sheet. If Destination Workbook is not specified, this property is optional and will default to Source Sheet. This property supports String variables and string formatted values.
  • Destination Workbook - The Drive Item of the Excel document where to paste the copied range. If not set, it will default to Source Workbook. This field supports only DriveItem variables.

Misc​

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.

Options​

  • What To Copy - The value formatting to paste. Select one of two options: Values, Formulas. The default value is Values.

Source​

  • Source Range - The range to copy. This property supports String variables and string formatted values.
  • Source Sheet - The name of the source sheet. This property supports String variables and string formatted values.
  • Source Workbook - The Drive Item of the Excel document from where to copy the range. Use the Find Files And Folders activity to retrieve this Drive Item. This field supports only DriveItem variables.