The TableTools work great for me, the only problem is when I hit save for excel it show Save as type : All Files(*.*), how can I save as .xls file? Thanks.
I have the same problem, with IE only. I'm using Tabletools 2.0 and I'm using sFileName to define a filename with an extension, but no extension shows up in IE. I know to add '.csv' or '.xls' to the filename, but my users don't. Has anyone else had this problem or know of a workaround?
Replies
[code]
$(document).ready(function() {
$('#example').dataTable( {
"sScrollX": "100%",
"sDom": 'CT<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "/swf/copy_cvs_xls_pdf.swf",
"aButtons": [ "copy",
{
"sExtends": "xls",
"sFileName": "TableTools.csv",
"bFooter": false
},
{
"sExtends": "pdf",
"sFileName": "TableTools.csv"
}
]
},
"aaSorting": [[1,'asc']],
"sPaginationType": "full_numbers",
"bStateSave": true
} );
} );
[/code]
[code]
...
"sFileName": "TableTools.csv",
...
[/code]
use
[code]
...
"sFileName": "*.xls"
...
[/code]