UiPath Activities Guide

Copy Paste Range

UiPath.Excel.Activities.ExcelCopyPasteRange

Copies an entire range, including values, formulas, table format, and cell format, and pastes it to a specified sheet.

Properties

Common

  • DisplayName - The display name of the activity.

Destination

  • DestinationCell - The starting cell where you want to paste the range. This field supports only strings and String variables.
  • DestinationSheet - The sheet you want to paste the range into. This field supports only strings and String variables.

Input

  • SheetName - The name of the sheet in the workbook where the change must be made. This field supports only strings and String variables.
  • SourceRange - The range you want to copy. This field supports only strings and String variables.

Misc

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

Options

  • CopyItems - A dropdown specifying what additional data to copy for the specified range. You can select between Value, Formula, NumberFormat, CellFormat, and All.

Example of Using the Copy Paste Range Activity

To exemplify how to use this activity, we have built an automation project which copies and pastes a range in an Excel workbook.
 
 
Download example


Copy Paste Range


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.