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:

To learn how to use this activity, see:

• Tutorial: Comparing Excel Files and Emailing Reconciliation Errors.
• Tutorial: Filtering Data in Excel.

In the Body of the Activity

• Source range - Click 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 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

• See the options in the body of the activity.

Misc

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