Export to Excel

arnop

When i add buttons to my datatables (or use the examples on datatables.net) using firefox and select open to open the generated xlsx Firefox gives it the .zip extension. How can i avoid this behaviour?

allan

Can you link to the page showing the issue please? Also, what version of Firefox and on what platform?

Allan

arnop

Just use the basic example (https://datatables.net/extensions/buttons/examples/initialisation/simple.html). When you click the excel button Firefox shows the open to open or save. With open it says this is: winzip file instead of excel file. When saving it it uses xlsx but on open it uses zip as an extension.

Firefox 42 on windows 7

allan

Thanks! Fix committed.

It will be in the next release and the nighties are rebuilding at the moment.

Allan

arnop

Thanks. That was a really fast response and fix.

arnop

Sorry to have to say this fix gave another issue it now creates a .xslx.xls file and excel give a warning about the file type. For xlsx u should use: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

allan

Embarrassing! Fixed and the nightly rebuilding again.

Thanks!
Allan

arnop

thanks!