Export to Excel IE Issue

cersos

I have an issue with exporting to Excel only in IE, it works fine in Firefox The Excel file is generated with an error:

We found a problem with some content in My Export.xlsx. Do you want us to try to recover...

I see something similar tracked in https://datatables.net/forums/discussion/comment/133425, but I'm not doing any custom code, simply:

buttons: [{extend: 'excelHtml5', title: 'My Export'}]

I'd try the nightly build, but I'm not sure how to integrate that with my page because I'm using one big consolidated downloaded js file and one css file.

IE 11
DataTables 1.10.18

PS: Works fine in IE11/DataTables 1.10.16

Steve

allan

Hi Steve,

Yes, the other thread covers the issue you are seeing.

Add the contents of this file at the end of your current consolidated file. It will overwrite the existing export buttons. You can remove them from the file if you want to not increase the file size.

Allan

cersos

Thanks @allen,

Worked like a charm.

Steve

cersos

Best supported "free" software on the internet. I can't think of 1 other tool I use that I post a question and get a response from the developer within an hour.

With that in mind I decided to become a supporter. Hopefully others will follow suit!

Steve

allan

Thank you !