When saving as Excel using Excel button from TableTools CSV option is offered.

When saving as Excel using Excel button from TableTools CSV option is offered.

muhaxmuhax Posts: 2Questions: 0Answers: 0
edited March 2013 in Bug reports
When wanting to save as Excel using Excel button from TableTools I am offered only CSV format.
If I manually change and save it as xls and than try to open it with Excel it complains about wrong format.
http://www.datatables.net/release-datatables/extras/TableTools/theme.html
On all examples with TableTools, try saving as Excel and you will be given option to save as CSV not XLS.
Is this a bug?

Replies

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Not a bug, a known, and currently accepted, limitation. See: http://datatables.net/forums/discussion/4043/export-to-excel-wrong-extention-.csv./p1 .

    Proper XLS format (or more likely XLSX) is a future enhancement for TableTools. Patches very welcome :-)

    Allan
  • kbeatykbeaty Posts: 12Questions: 0Answers: 0
    Has anyone else seen this issue: http://datatables.net/forums/discussion/14527/tabletools-file-extensions-are-not-inserted-when-using-chrome#Item_1
  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    I've posted a reply in your other thread.
This discussion has been closed.