Inaccurate TableTools Export Data
Inaccurate TableTools Export Data
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
} );
} );
This discussion has been closed.
Answers
Can you link to a test case showing the issue so it can be debugged please?
Allan
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
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
Here's the output file: https://dl.dropboxusercontent.com/u/47116798/Test.csv
Any further thoughts Allan?