Export table header and body, but not the footer

Export table header and body, but not the footer

radi8radi8 Posts: 31Questions: 6Answers: 0
edited October 2013 in TableTools
I am using the footer to add selection filtering similar to: http://datatables.net/release-datatables/examples/api/multi_filter_select.html. When using the Table Tools on this type of format, the last page will display all of the filters (tfoot row).

Is there a method where I can exclude this row of garbage data?

Replies

  • radi8radi8 Posts: 31Questions: 6Answers: 0
    edited October 2013
    Found it!
    [code]
    var oTable = $('#'+tablename).dataTable( {
    "sDom": "<'row'<'dataTables_header clearfix'<'col-md-4'l><'col-md-5 hidden-sm hidden-xs'T><'col-md-3 col-sm-5'f>r>>t<'row'<'dataTables_footer clearfix'<'col-md-6'i><'col-md-6'p>>>",
    "oTableTools": {
    "sSwfPath": 'https://'+ window.location.hostname + '/js/DataTables/media/swf/copy_csv_xls_pdf.swf',
    "aButtons": [
    "print" ,
    {
    "sExtends": "collection",
    "sButtonText": "Save",
    "aButtons": [{
    "sExtends": "xls",
    "bFooter": false // <-- THIS
    },
    {
    "sExtends": "pdf",
    "sPdfOrientation": "landscape" ,
    "bFooter": false //<-- THIS
    },
    ]
    }
    ]
    },
    "sSearch": "Search all columns:",
    "sPaginationType": "full_numbers",
    "aoColumns": col
    } );
    [/code]
This discussion has been closed.