Need a help in copying sheet from one excel file to another. The excel file is large thus Copy sheet activity is not working best and Excel macro is too not giving results.
@supermanPunch - can you help with some interop code to copy one sheet to another workbook?
@ppr @nikhil.girish @ashwin.ashok @Srini84 @Gokul001 @Dave @Nithinkrishna can you guys help?
Actually excel activity will work on this
Try upgrading your excel package and give a try
Go to design tab → manage packages → all packages → upgrade excel activity and give a try
We can use the custom activity from uipath marketplace
Refer this thread for details
I have included the below new custom components in the package.
1.Create Workbook.(Create a new worksheet)
2.Copy to File (Copy the worksheet to another excel file).
3.Copy to WorkBook (Copy the worksheet inside the workbook).
4.HideUnhide the worksheet
5.Protect Unprotect the worksheet
CreateWorkbook.zip (18.5 KB)
Copy To File
This activity copies the work sheet to an another excel file. If the another file is not ex…
Try this as a first option and then go for custom component
Thanks for this!! But I cannot use outside packages and on the upgrading excel part it is already to latest, actually the excel file is very large thus the excel application scope is itself taking more than expected time to go inside body therefore copy sheet is not executing. I am thinking if I am able to copy sheet to another file then that would make work directly more efficient.
Let’s try upgrading the package and give a try
Try Checking the Below Workflow :
Excel_CopySheet_ToAnotherExcel.xaml (7.6 KB)
It does take time for a Sheet containing Large Data.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.