Copy Sheet from excel to other excel


#1

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


#2

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


#3

@irahmat

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

Regards,
Mahesh


#4

Hi @MAHESH1,

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


#5

@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


#6

Hi @sreekanth,

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


#7

Hi @irahmat,

This will help you.

Regards
Balamurugan.S