Copy Sheet from One Excel to Another

[Shikhar_Tandon]

Hi Everyone,

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.

Any recommendations?
@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?

Thanks

[Palaniyappan (Palaniyappan P)]

Hi

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

Or

We can use the custom activity from UiPath marketplace

Refer this thread for details

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…

Cheers @Shikhar_Tandon

[Palaniyappan (Palaniyappan P)]

@Palaniyappan

Go to design tab → manage packages → all packages → upgrade excel activity and give a try

Try this as a first option and then go for custom component

@Shikhar_Tandon

[Shikhar_Tandon]

Hi @Palaniyappan,

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.

Thanks

[Palaniyappan (Palaniyappan P)]

Fine

Let’s try upgrading the package and give a try

@Shikhar_Tandon

[Shikhar_Tandon]

Tried not working

[Sanjit_Pal]

@Shikhar_Tandon

1. If copy sheet is not working than you can use read range activity to read the data from one excel and can use write range activity to write the same datatable to the other excel file.

2. If you are unable to read the file using the default activity like read range, you can go with the alternative to use the Excel As Database to read and write, from and to the excel.

[supermanPunch (Arpan)]

Hi @Shikhar_Tandon ,

Try Checking the Below Workflow :
Excel_CopySheet_ToAnotherExcel.xaml (7.6 KB)

It does take time for a Sheet containing Large Data.