0

How can we export the contents of the jQuery Datatables to proper Excel format? The current implementation only exports to .csv file. Does any one have a demo or working example for this?

More details are the discussion here and here.

Derek 朕會功夫
  • 92,235
  • 44
  • 185
  • 247
Eldo
  • 391
  • 1
  • 7
  • 16
  • use an excel library on server – charlietfl Dec 29 '12 at 00:46
  • 1
    Use the [Table to CSV](http://archive.plugins.jquery.com/project/tableToCSV) plugin for jQuery. Detail: [Stackoverflow: jQuery Table to CSV export](http://stackoverflow.com/questions/921037/jquery-table-to-csv-export) – Derek 朕會功夫 Jan 02 '13 at 21:52

1 Answers1

2


If you want to export in excel only format you have to modified the "TableTools.min.js" file. You have to open "TableTools.min.js" file and replace ".csv" with ".xls" word. Then it will work export proper Excel format.

Also if you want download updated "TableTools.min.js" download by below link.

https://drive.google.com/file/d/0B8IHTmhRUyLpcjhnWWpOR3k3dlE/edit?usp=sharing

Thanks & Regards
Deepak Joshi
9899835174

Deepak Joshi
  • 1,036
  • 7
  • 17