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

[Jim_Yang_1117 (Jim Yang)]

Hi, all, I am a new user of UIPATH. Could anyone share me a sample how to copy one sheet in one Excel file to a sheet in another Excel file with UIPATH?
Besides invoke VBA macro, is there any other activities to support this ? Thanks

[pravin_calvin (pravin kumar)]

Hi @Jim_Yang_1117

We can try with read range and write range activities!

Regards

[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

[pravin_calvin (pravin kumar)]

Hi @Jim_Yang_1117

And also have a view on thread below!

Copy/Move Excel Sheets to Other WorkBook

Hi All, I want to copy/move excel sheets to other workbook. I have checked the link for the excelcopysheet activity, but it is not available in my studio (version 2018.2) we need the data to be copied with source formatting and we need to copy more than 10 sheets from 4-5 workbook to one workbook. checked this link as well, but no hope

Regards

[Jim_Yang_1117 (Jim Yang)]

Thanks, @pravin_calvin , i think it may be a solution, but it needs to read to datatable parameter first and write datatable to destination position. Is there any other activities to simulate Excel operation , such as

1. Open file1, select sheet1, ctrl+a, ctrl+c
   2 Open file2, select sheet2, ctrl+v

[pravin_calvin (pravin kumar)]

Hi @Jim_Yang_1117

We can try with excel application scope!

Regards

[Jim_Yang_1117 (Jim Yang)]

@Gokul001 , Thanks, although the solution is not i expected, i can try this. Let me try it first.

[gabrielribas4 (Gabriel Ribas)]

Hey @Jim_Yang_1117 !! Welcome to the automation world!!

Here is your sample!

• Step 1: First of all let’s get our two worksheets. I will use “Test1” which contains the following data.
  
  

And the excel “Test2” which is empty and is where we will paste the data from the worksheet “Test1”

• Step 2: Well, to start we need to include the “Excelp Application Scope” activity so that we can use an excel file. Look:
  

  
  
  We passed the path in the field of “Workbook Path” and the properties can be left as in the photo, but it is worth studying and exploring later!

• Step 3: To read the data from an excel spreadsheet, let’s use the “Read Range” activity.
  

Attention here!! We have two Read Range activities. “Excel” and “Workbook”. When we use “Excel Application Scope” we will use the first one, from “Excel”. Then look up the difference between the two.

To store an excel table in our code, we need to create a variable of type “DataTable”. Look:

Pass this variable in the “Output” of the “Read Range” activity.

• Step 4: As in reading, we are going to use “excel Application Scope” but we are going to use excel’s “Write Range” activity. Watch:
  
  

Files:
Main.xaml (10.3 KB)
Test1.xlsx (8.7 KB)
Test2.xlsx (9.6 KB)

Hope it helps!!

[Gokul001 (Gokul Balaji)]

Hi @Jim_Yang_1117

Okay then for using Send hotkey activity

Have look on the document and video it may help you

How to send Hotkeys to specific Excel Cells in UiPath - Full Tutorial

Or else you can also try with copy\paste range or copy sheet activities

Regards
Gokul

[Rahul_Unnikrishnan]

Hello @Jim_Yang_1117

Can check the below video

Merge Multiple Excels to Single Excel using UiPath | Input sheets to separate sheets in output Excel

Thanks

[Kro_Raoq]

Hello Gokul, is this working with an image on a sheet excel file? Thank youu