datatable export to excel give error excel found unreadable content in xxx.xlsx file

majahar

Hi,
I added export to excel button in datatable. but sometimes after downloading excel it cant open it and gives error "excel found unreadable content in xxxx.xlsx. Do you want to recover content of this file". I cant find for which character it is giving this error.
How to resolve it.

Thanks.

kdpowell

I had the same issue. I am using php and had to use htmlentities() around the value coming into my table cell/s. This solved it for me.

allan

Happy to take a look if you post a link to a test case please. This should have been addressed in the latest versions of Buttons.

Allan