search

rainabba / jquery-table2excel

jQuery Plugin to export HTML tabled to Excel Spreadsheet Compatible Files
593 stars 666 forks source link

Issue with xlsx - xls works #25

Closed olimortimer closed 8 years ago

olimortimer commented 8 years ago

I've found that outputting the file as a xlsx creates a corrupt file / not recognised properly by Excel or OpenOffice / LibreOffice.

Changing the output to xls works fine, and it can be opened correctly.

You might want to allow people to specify the extensions when passing 'filename', as they might find xlsx doesn't always work.

Gaohaoyang commented 8 years ago

I got same problem. @olimortimer How do you fix it?

I use Chrome47, Office 2013, Windows 10

olimortimer commented 8 years ago

Try changing the output file extension from xlsx to xls

Gaohaoyang commented 8 years ago

Thanks, I did this

rainabba commented 8 years ago

@Gaohaoyang Did that change do what you wanted?

olimortimer commented 8 years ago

I thought it had solved my issue (Mac OSX, using Libre Office), but I've reports from a client that the XLS won't open on their Windows Microsoft Office

rainabba commented 8 years ago

My experience is that .xls won't open at all, but .xlsx will with a warning so I'm going to close this. Keep in mind that this is a hack so it likely won't work in a consistent manner.