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?
-
use an excel library on servercharlietfl– charlietfl2012-12-29 00:46:20 +00:00Commented Dec 29, 2012 at 0:46
-
1Use the Table to CSV plugin for jQuery. Detail: Stackoverflow: jQuery Table to CSV exportDerek 朕會功夫– Derek 朕會功夫2013-01-02 21:52:35 +00:00Commented Jan 2, 2013 at 21:52
Add a comment
|
1 Answer
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
