xls button converting big number to scientific notation

luisfelipedejesusm

When I export data from datatable it automatically convert big numbers like 1542658964667 into 1.54266E+12.

I've tried using $('row c[r^="A"]', sheet).attr( 's', '50' ) and $('row c[r^="A"]', sheet).attr( 's', '0' ) but none of those works.

Any Idea how to correctly represent big numbers as string when exporting to excel?

colin

Hi @luisfelipedejesusm ,

This thread here should sort you out,

Cheers,

Colin