Export to Excel has .csv extension, why not .xls?

Export to Excel has .csv extension, why not .xls?

step1020304050step1020304050 Posts: 3Questions: 3Answers: 0

Hi All,

I'm using Datatables 1.10 and using the table tools extension. I was exporting using the excel button, but it is saved as .csv.
Why is it not exported as .xls?

Please help.

Answers

  • allanallan Posts: 54,701Questions: 1Answers: 8,556 Site admin

    Because it is not an xls file. You can use the TableTools options to change the extension if you want, but modern versions of Excel will report the file as corrupt (old versions worked just fine and TableTools did use an xls extension).

    One day I'll get around to writing a real xlsx exporter...

    Allan

This discussion has been closed.