Unable to export table footers to xls and csv put works for prin using Tabletools?
Unable to export table footers to xls and csv put works for prin using Tabletools?
James Payne
Posts: 15Questions: 0Answers: 0
Hello,
I'm using Tabletools to export my data and everything is working fine except my column totals I have in the footer are not being exported when I copy to clipboard or export as a csv or xls. If I print the data it works fine.
Any ideas why this is happening?
I'm using the latest version of both datatables and tabletools. Here is my initialization code
[code]$(document).ready(function() {
TableToolsInit.sSwfPath = "../library/swf/ZeroClipboard.swf";
$('#view_booking_forms').dataTable({
"sDom": 'T=<"clear"><"H"lfivp>rt<"F"ip>' ,
"bJQueryUI": true,
'bProcessing':true,
"bServerSide":true,
"bSort":true,
"sPaginationType": "full_numbers",
"sAjaxSource": "includes/datatable_form_parsers/view_booking_forms_parse.php",
"oLanguage": {
"sLengthMenu": 'Display 102550100250Allrecords…'
},
"fnFooterCallback": function ( nRow, aaData, iStart, iEnd, aiDisplay ) {
var iTotal = 0;
for ( var i=0 ; i
I'm using Tabletools to export my data and everything is working fine except my column totals I have in the footer are not being exported when I copy to clipboard or export as a csv or xls. If I print the data it works fine.
Any ideas why this is happening?
I'm using the latest version of both datatables and tabletools. Here is my initialization code
[code]$(document).ready(function() {
TableToolsInit.sSwfPath = "../library/swf/ZeroClipboard.swf";
$('#view_booking_forms').dataTable({
"sDom": 'T=<"clear"><"H"lfivp>rt<"F"ip>' ,
"bJQueryUI": true,
'bProcessing':true,
"bServerSide":true,
"bSort":true,
"sPaginationType": "full_numbers",
"sAjaxSource": "includes/datatable_form_parsers/view_booking_forms_parse.php",
"oLanguage": {
"sLengthMenu": 'Display 102550100250Allrecords…'
},
"fnFooterCallback": function ( nRow, aaData, iStart, iEnd, aiDisplay ) {
var iTotal = 0;
for ( var i=0 ; i
This discussion has been closed.
Replies
[code]
jQuery('#table_select').dataTable({
"bJQueryUI": true,
"sScrollX": "100%",
"sDom": '<"H"<"toolbar">lfrT>t<"F"ip>',
"aLengthMenu": [[5, 10, 25, 50, -1], [5, 10, 25, 50, "All"]],
"oTableTools":{
"sRowSelect": "single",
"aButtons": [
{
"sExtends": "copy",
"bFooter": true,
"mColumns": [0,1,2,3]
},
{
"sExtends": "xls",
"mColumns": [0,1,2,3],
"bHeader": true,
"bFooter": true
},
{
"sExtends": "pdf",
"bFooter": true,
"mColumns": [0,1,2,3]
},
{
"sExtends": "print",
"bFooter": true,
"mColumns": [0,1,2,3]
}
]
}
});
[/code]
i am facing same problem
please some one give the solution for that....
thanks