TableTools Exporting to Excel
TableTools Exporting to Excel
Hello,
I´m using TableTools in my DataTables but i have a problem. Every button is working fine except the one which exports to Excel.
Clicking on this button, it´s saving as CSV file. This button has the same behavior than CSV button.
This is my DataTable initialisation
[code] oTable = $('#received').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"sDom": '<"H"Tfr>t<"F"ip>',
"iDisplayLength": 5,
"aoColumnDefs": [
{ "bSearchable": false, "bVisible": false, "aTargets": [ 0 ] },
],
"oTableTools": {
"sSwfPath": "/Content/TableTools/copy_csv_xls_pdf.swf",
"aButtons": [
"copy", "csv", "xls", "pdf",
{
"sExtends": "collection",
"aButtons": [ "csv", "xls", "pdf" ]
}
]
}
});
[/code]
Any idea?
Thanks in advance
I´m using TableTools in my DataTables but i have a problem. Every button is working fine except the one which exports to Excel.
Clicking on this button, it´s saving as CSV file. This button has the same behavior than CSV button.
This is my DataTable initialisation
[code] oTable = $('#received').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"sDom": '<"H"Tfr>t<"F"ip>',
"iDisplayLength": 5,
"aoColumnDefs": [
{ "bSearchable": false, "bVisible": false, "aTargets": [ 0 ] },
],
"oTableTools": {
"sSwfPath": "/Content/TableTools/copy_csv_xls_pdf.swf",
"aButtons": [
"copy", "csv", "xls", "pdf",
{
"sExtends": "collection",
"aButtons": [ "csv", "xls", "pdf" ]
}
]
}
});
[/code]
Any idea?
Thanks in advance
This discussion has been closed.
Replies
http://datatables.net/forums/discussion/10669/export-in-excel-format#Item_3
Then...anybody knows how to modify TableTools in order to export as XLS format?
Cheers!
Allan