How to copy and paste sheet from one excel file to another excel file?

[jumanah_alqurashi (juman)]

how to copy and paste sheet from one excel file to another excel file?

i have attached my sequence

[lukasziebold]

Hi,

does the Copy Sheet activity you are using in your screenshot not work?
I am noticing you have hardcoded the values for the properties DestinationSheetName and SheetName, i think you want to use the current SheetNames (sheet2?), that you have in your ListOfSheets.

If all else fails, you can still just read range from one sheet, then write range to another one.

[jumanah_alqurashi (juman)]

yes its not working
and yes i want to use sheet2 but am not sure how because it says its already a usen name and just to copy that sheet

can you please tell me how to use the write range from one sheet then write to another excel file ?

[ermanoj3101 (MANOJ)]

Hi @jumanah_alqurashi ,

Check below post

How to copy data from one excel workbook to another excel workbook

Hi @gulshiyaa Your working are work for me with equivalent data. But when the time I plugged in my original data the error occurred. [Capture] How am I going to fix this error? Thanks and best regards.