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

[yushinchan]

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.

[gulshiyaa]

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

If you find it useful mark it as solution and close the thread

cool,
Regards,
Gulshiyaa

[tera]

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

Thanks.
-Tera

[yushinchan]

Hi @gulshiyaa

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

How am I going to fix this error?

Thanks and best regards.

[balupad14 (Balamurugan)]

Hi @yushinchan,

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

Here is the package link :

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

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

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed some activities to make easy excel automation. Package manage Search keyword: Balareva.easyexcel An activity library that makes Excel automation very easy This package contains activities that will help automate your work with Excel. The below activities are available: ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images. ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet. The e…

Regards
Balamurugan.S

[Natapong (Natapong Raojutitam)]

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

[balupad14 (Balamurugan)]

Thank you @Natapong…