CODEWITHSUNDEEP
javascriptjqueryexcelcsvdatatables
Eldo
Eldo

Reputation: 391

jQuery Datatables export to Excel in correct format

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.

Upvotes: 0

Views: 5255

Answers (1)

Deepak Joshi
Deepak Joshi

Reputation: 1066


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

Upvotes: 2

Related Questions