Inaccurate TableTools Export Data

Inaccurate TableTools Export Data

adam12adam12 Posts: 8Questions: 3Answers: 0

Hey guys,

First off, amazing product, I've been using on quite a few projects of mine.

I'm using TableTools to export to XLS. For whatever reason (I've tried everything I can think of to correct), the output file does not match the data on the table. There are a cells missing, and data added where there wasn't data. It's mainly in columns further out, i.e. it gets the first 3 columns or so of data correct. I'm a bit at a loss. ColVis works perfectly. All other aspects of the export work flawlessly as well.

Best,

Adam

Here's my js:

$(document).ready(function() {
    var table = $('#matrixTable').dataTable( {

        dom: 'TC<"clear">lfrtip',
        oColVis: {"aiExclude": [ 0 ],showAll: "Show all", buttonText: "Show / Hide Realms", iOverlayFade: 100},
        bPaginate: false,
        bInfo: false,
        bFilter: false,
        ordering: false,
        scrollY: "800px",
        scrollX: "100%",

        tableTools: {aButtons: [{sExtends: "xls", sButtonText: "Export .xls", sSwfPath: "../swf/copy_csv_xls.swf" }]
            //sSwfPath: "../whatIsWhatWS/swf/copy_csv_xls.swf"
        }
    });

var colvis = new $.fn.dataTable.ColVis( table );


    new $.fn.dataTable.FixedColumns( table, {
         leftColumns: 1
    } );
} );

Answers

This discussion has been closed.