DataTable export in xlsx

filippoaceto

Hi,
i want to export datatables value in excel file but when i have a number greater than 15 cifres, excel report has the scientific notation, with exponent.

I try to render the data with a space in the data field but did not work.
What i could try?

Thanks.

allan

You need to use the customize callback to set the cell to be plain text styling rather than number styled. This example shows how to set a style for a cell and excelHtml5 documents the built in style options.

Allan