DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

DataTable export in xlsx

DataTable export in xlsx

filippoacetofilippoaceto Posts: 4Questions: 0Answers: 0
in Free community support

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.

Replies

  • allanallan Posts: 65,421Questions: 1Answers: 10,864 Site admin

    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

This discussion has been closed.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2025 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.