CSV Export Without Rounding Up Numbers
CSV Export Without Rounding Up Numbers
wallabe123
Posts: 24Questions: 13Answers: 0
I am using the csvHtml5 button to export rows of a DataTable. There are columns with numbers of around 13 characters which need to be kept exact. The export function rounds up these numbers and truncates them. Is there a way around this?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Are you opening the CSV file in a text editor or a spreadsheet? The CSV export data should be what is shown in the table. However you could be using
columns.renderto do some data manipulation which could change the export. Please provide a link to your page or a test case replicating the issue so we can help debug.https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case
Kevin
@kthorngren thanks for your help - it was just the software I was using to open the CSV data. Think I was having one of those days!