Export to xls not working for 31 character

anshar

Hello,

I have data displayed using datatable, when I want export it using Xls, some columns don't appear as it should be,
in datatable 1160084613132864023130418111143, but when I export to xls, it becomes 1160084613132860000000000000000.

Could you tell me, what I supposed to do ?

Thanks

anshar

Here it is https://jsfiddle.net/ansharfirman/rh0hbag3/

colin

Hi @anshar ,

It's because it's being converted to a scientific number. Emiliio Esteve's answer on this StackOverflow thread gave this answer.

Hope that does the trick,

Cheers,

Colin

anshar

Hi @colin ,

Thanks, I have done to add quotes around the data. Was hoping I can use TableTools as they have a lot off useful features..

Cheers,

Anshar

lisarush

See this discussion as well -- Excel rounds the numbers.
https://datatables.net/forums/discussion/comment/132633#Comment_132633