How to copy sheet tab data to other sheet tab in excel without affecting the template?

[AhmedKutraphali]

I have a process where I readrange from an excel file and then copy the data on sheet1 and create another sheet which is sheet2 and then copy data from sheet1 to sheet2. I used read range , write range and write cell but the template is destroyed and affected when using write cell. How the data is presented is sheet1 it should be the same with sheet2 after copying …Any idea with this one ? Thanks.

How the data presented in sheet1 it should be the same when copied to sheet2 including template , fonts , color etc. including the data.

Book1.xlsx (9.0 KB)

DoubleClick.xaml (4.9 KB)

[Marius_Puscasu]

How create tabs in excel without opening it?

Hi @Jelrey , The you should replace the Read Range & Write Range from the provided example with the Duplicate Sheet activity ( https://docs.uipath.com/studiox/v2019/docs/duplicate-sheet-x ) from Studio X Keep the Write Cell activity in order to add the cell with the current date Hope this helps Best regards, Marius