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

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

i have attached my sequence

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.

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 ?

Hi @jumanah_alqurashi ,

Check below post