Inaccurate TableTools Export Data

adam12

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
    } );
} );

allan

Can you link to a test case showing the issue so it can be debugged please?

Allan

adam12

I can build a test case ported to the outside but would take a bit, this is being used on a a proprietary inside tool. Here is a link to the existing table with some test data, and the corresponding output xls file. Let me know if this helps.

https://dl.dropboxusercontent.com/u/47116798/table.png

https://dl.dropboxusercontent.com/u/47116798/export.png

allan

Very odd. What does created file look like if you open it in a text Editor? (it is just a CSV file - although UTF16-LE encoded).

Allan

adam12

Here's the output file: https://dl.dropboxusercontent.com/u/47116798/Test.csv

adam12

Any further thoughts Allan?