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

Hi there,

I was about to copy data table from one excel workbook to another excel workbook which had been existed with an existing data table. For clearly explanation, I attached two .xlsx file which named Excel 1 and Excel 2. Excel 1.xlsx (8.0 KB) Excel 2.xlsx (10.4 KB)

I want to copy the data table from Excel 2 and paste it beside the data table from Excel 1 using UiPath and my result would end up be like following attached image.

Is there any way to do so? I looking forward any assistance from you.
Thanks and best regards.

1 Like

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

3 Likes

Hi.
If you want to copy styles etc., how about this method?
Sample.zip (27.4 KB)

Thanks.
-Tera

2 Likes

Hi @gulshiyaa

Your working are work for me with equivalent data.
But when the time I plugged in my original data the error occurred.
Capture

How am I going to fix this error?

Thanks and best regards.

Hi @yushinchan,

You can use the “Copy To WorkBook”. Generally it copies the sheet one workbook to another workbook.

image

Here is the package link :

Another way you can use “Copy ToClipboard” and “Paste Clipboard” activity from this

Regards
Balamurugan.S

2 Likes

Hi @yushinchan

You can refer below file for guideline to using [BalaReva EasyExcel] Activity to do that you want.
CopyPaste.zip (27.9 KB)

Hi @balupad14
I try to using [BalaReva EasyExcel] Activity.
It was really nice activity packages!
I love it :heart_eyes:

3 Likes

Thank you @Natapong

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.