Hi Supppot,
We have noticed an issue with generated excel file when you Copy Range across sheets & workbooks using .cells API. Basically ouput file get generated with out any error but when open the file in Microsoft office it prompt you for unreadable content. It looks like that XML within the generated excel is not valid. I am attaching the sample project for your reference.
Thanks,
Imran.