Copy Sheet from excel to other excel

[irahmat (Indra Rahmat)]

Hi RPA Dev,

I have a case with excel that There is some sheet I need to copy to Template excel contained a formula.

does anyone know how to do it?

Regards,
Indra

[VISHNU07 (Mahavishnu.N)]

You can use build datatable activity to store the excel data’s
And you can use them in another excel file

[MAHESH1 (MAHESHKUMAR JV)]

@irahmat

Do you want to copy the entire data from one excel sheet to another excel template

Regards,
Mahesh

[irahmat (Indra Rahmat)]

Hi @MAHESH1,

Yes, that is what I want. do you know how?
note: I don’t like to use for each row activity.

[sreekanth]

@irahmat, Use read range of Excel and its output will be a data table.Use Write range (or) Merge data table and write it to another excel file.
Thanks,
Sreekanth.k

[irahmat (Indra Rahmat)]

Hi @sreekanth,

It’s working, Thank’s but how to bring along with format?

[balupad14 (Balamurugan)]

Hi @irahmat,

This will help you.

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…

Regards
Balamurugan.S