EDN Admin
Well-known member
Hello All <br/>
I have this issue that occurs with me and driving me crazy ...<br/>
i have a report that contains thousands of records and i need to export it to excel , but the excel normal extension .xls<br/>
is showing missing records at the end of the file , so i save my file as an .xlsx extension it saves correctly but when i open the file it generates an error
"Excel cannot open the file <var>filename</var>.xlsx because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
but when i test the file i drag it and open it in an empty notepad all the records shows up correctly
<br/>
any help would be appreciated ,<br/>
thank you a lot<br/>
Best regards
View the full article
I have this issue that occurs with me and driving me crazy ...<br/>
i have a report that contains thousands of records and i need to export it to excel , but the excel normal extension .xls<br/>
is showing missing records at the end of the file , so i save my file as an .xlsx extension it saves correctly but when i open the file it generates an error
"Excel cannot open the file <var>filename</var>.xlsx because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
but when i test the file i drag it and open it in an empty notepad all the records shows up correctly
<br/>
any help would be appreciated ,<br/>
thank you a lot<br/>
Best regards
View the full article