How to copy one sheet in one Excel file to a sheet in another Excel file with UIPATH

[Gokul001 (Gokul Balaji)]

HI @Jim_Yang_1117

You can follow this steps

• Use excel Application Scope
  • Read Range, pass your sheet and store in the DataTable
• Use another excel application scope and write range activity inside that Write Range and pass the DataTable you created above and pass your sheet. And give different File location

Like this

Find Xaml skeleton for your ref
Sample.xaml (7.1 KB)

You can also look on the thread for ref

How to copy data from one excel workbook to another excel workbook

Hi @yushinchan Use Two workbook Read range and pass the path and Use workbook write range and pass the Excel1 path and in range the “F1” and pass the 2nd workbook sheet dt and enable the add headers check this zip file Join_dt.zip (31.5 KB) Extract file and open [image] If you find it useful mark it as solution and close the thread cool, Regards, Gulshiyaa

Regards
Gokul