Hi @Baby123 ,
1.You can store the data rows of the excel in a list or in the other data table.
2.Then try to write that data table in the other excel.
Any doubts please let me know…
Or else you can go through this post(another way):
Thanks & Regards,
Shubham Dutta