Copy Sheet from excel to other excel

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

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

@irahmat

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

Regards,
Mahesh

Hi @MAHESH1,

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

@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

Hi @sreekanth,

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

1 Like

Hi @irahmat,

This will help you.

Regards
Balamurugan.S

2 Likes