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.
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
If you want to copy styles etc., how about this method?
Sample.zip (27.4 KB)
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.
You can use the “Copy To WorkBook”. Generally it copies the sheet one workbook to another workbook.
Here is the package link :
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.
This package is having the below activities.
Pie Chart - Using these activities you can able to generate the Pie Chart
Column Chart - Using these activities you can able to generate the Column …
Another way you can use “Copy ToClipboard” and “Paste Clipboard” activity from this
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.
You can refer below file for guideline to using
[BalaReva EasyExcel] Activity to do that you want.
CopyPaste.zip (27.9 KB)
I try to using [BalaReva EasyExcel] Activity.
It was really nice activity packages!
I love it
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.