uipath technical infomation for everyone

Copy sheet

Use the Copy Sheet activity to copy sheets.

Copy sheets

Suppose you have the following sheet in sample1.xlsx. Let’s look at an example of copying this sheet to sample2.xlsx.

1 Open Excel in the Excel Application Scope activity.
2 Place a Copy Sheet activity within the Excel Application Scope activity.

3 Set the properties of the Copy Sheet activity.

Properties Commentary
DestinationFilePath Specify the copy destination Excel file path.
DestinationSheetName Specify the copy destination sheet name.
SheetName Specify the sheet name to copy.


Sample2.xlsx after robot execution