Tabletools Export CSV and Excel

svitucci

Tabletools Export CSV and excel: long numbers are not formatted as numbers but as "general"
1234567890112 is exported as 1.23457E+12

This is how I have it formatted in code

"aoColumns": [

/* Cir/Medical Record */ { "sSortDataType": "dom-text", "sType": "numeric"},

/* Cir/Medical Record */ { "sSortDataType": "dom-text", "sType": "numeric"},

Thank you
su

allan

This is noted in a number of other threads - there is no formatting of the data exported by Tableztools - what you are seeing is the default Excel formatting for the imported data. You'd need to use a more complete program to export the data if you want control over the formatting - probably a server side script.

Allan

svitucci

I understand .....
Thank you

manujain16

how to add msg similar to sPdfMessage On the click of excel/cvs button of tooltable? basically i want to add some data on the top of the datatable data on the click of excel/cvc button of tooltable, please give some idea or code

allan

There is no option for that at the moment. You would need to modify the TableTools code.

Allan

manujain16

Could you please provide some sample code on how to go about it or which function of table tool need to be modified to achieve this feature so that i can append my data on the top of the tabletool data before exporting it to excel

allan

Happy to do this under the DataTables support option: http://datatables.net/support .

Allan

PriyankaDubey

I am not able to see the buttons for exporting the datatables to CSV,Excel,PDF,Print
Can u plz provide me a sample code for each of the functions
Plz reply itz very urgent

tangerine

http://www.datatables.net/forums/discussion/12899/post-test-cases-when-asking-for-help-please-read