TableTools - Export To Excel
TableTools - Export To Excel
I'm using the latest version of table tools and for some reason the export to excel function is not working. I've tried debugging the tables tools JavaScript, but the 'fnClick' event is not even firing. I have 5 other datatables instances that use the same code that work fine, but this one is not working, please help. Thanks. Also, I've tried in FireFox and IE 9 and neither one work.
Here is my debug info: https://debug.datatables.net/ekuhis
'xls': $.extend({
}, TableTools.buttonBase, {
'sAction': 'flash_save',
'sCharSet': 'utf16le',
'bBomInc': true,
'sButtonClass': 'DTTT_button_xls',
'sButtonText': 'Excel',
'fnClick': function (nButton, oConfig, flash) {
this.fnSetText(flash, this.fnGetTableData(oConfig));
}
}),
oTableTools: {
sSwfPath: "/Content/DataTables-1.9.4/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",
aButtons: [
{
sExtends: "xls",
sButtonText: 'Export Page To Excel',
sFileName: 'ExportDoc' + '.csv',
mColumns: [1, 2, 3, 4, 5, 6, 7],
fnCellRender: function (sValue, iColumn) {
return ExtractData(sValue, iColumn, ', ');
}
},
{
sExtends: "print",
bShowAll: false,
sButtonText: 'Print Page',
sInfo: 'Print View'
}
]
},