Excel Copy Sheet activity is not working when i move the project to a different system

[thoufyashraf (Thoufeek Ashraf)]

Hi Support,

I have two systems where UI path is installed both having same version and licensed. I have implement an excel copy sheet activity, When I run in developer environment it is copying the sheet from Source excel and paste to other excel file. and when I move to production the activity is not working.

also one thing I have noticed is in developer environment it is copying the data in source excel and destination excel file as well in the sheet name I have provided.

in Developer it is copying in source excel but not copying in destination excel.

Note: I don’t want to copy in source excel again I want to copy the sheet to destination excel only.

Could some one help me to sort out the issue

[Latika10011740 (Latika V N Durga Bhavani)]

hi @thoufyashraf

please check this post might help you,

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

Thanks
Latika

[balupad14 (Balamurugan)]

Hi @thoufyashraf,

Take a look at this…

BalaReva.Excel.Activities

Hi Friends, 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 [image] Create WorkBook Properties [image] Sample : 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…

Thank you
Balamurugan.S