Subscribe

UiPath StudioX

The UiPath StudioX Guide

Copy Paste Range

UiPath.Excel.Activities.Business.CopyPasteRangeX

Copies a range or sheet and pastes it to another location in the current workbook or a different one. You can copy values, formulas, number and cell formats, and transpose (rotate) data.

The following table lists supported copy-paste combinations:

Copy from

Paste to

Sheet

Sheet

Range

Sheet

Range

Range

Range

Cell

Cell

Cell

Cell

Range

To learn how to use this activity, see:

In the Body of the Activity

  • Source range - Click plus buttonplus button on the right side of the field and then, from the menu, select a named range, table, or sheet to copy, or select Indicate in Excel to open the file and select a range directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.
  • Destination range - Click plus buttonplus button on the right side of the field and then, from the menu, select a named range, table, or sheet where to paste the copied data, or select Indicate in Excel to open the file and select a range directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.
  • What to copy - Select how to copy the data. The following options are available: All (the default option), Values, Formulas, Formats.
  • Transpose - If selected, the copied range is rotated (rows to columns and columns to rows).

Properties

Common

  • Display Name - The name displayed for the activity in the Designer panel.

Input

Misc

  • Private - If selected, the data used in the activity is not logged by StudioX.

Updated 2 years ago


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.