TableTools Exporting to Excel

TableTools Exporting to Excel

equisdeequisde Posts: 34Questions: 0Answers: 0
edited July 2012 in Plug-ins
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

Replies

  • equisdeequisde Posts: 34Questions: 0Answers: 0
    Ok. I have found a response about this matter

    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!
  • allanallan Posts: 63,498Questions: 1Answers: 10,470 Site admin
    See my comment here: http://datatables.net/forums/discussion/10669/export-in-excel-format#Item_2

    Allan
  • equisdeequisde Posts: 34Questions: 0Answers: 0
    Thank you allan :)
This discussion has been closed.