Is there a way to format one of the columns on a CSV export so that it is treated as quoted text?
I have a column that contains tracking numbers and if there are any leading zeros, the data is being truncated when the file is opened in Excel.
I think you will find that wrapping quotes around cell data when exported as a CSV will be seen if opened in Excel. If you want to format the data for Excel you should use the Excel export option. There are lots of threads discussing how to convert strings to text for Excel, like this one: https://datatables.net/forums/discussion/comment/163754/#Comment_163754
Answers
These two examples show how to modify the exported data:
https://datatables.net/extensions/buttons/examples/html5/outputFormat-orthogonal.html
https://datatables.net/extensions/buttons/examples/html5/outputFormat-function.html
I think you will find that wrapping quotes around cell data when exported as a CSV will be seen if opened in Excel. If you want to format the data for Excel you should use the Excel export option. There are lots of threads discussing how to convert strings to text for Excel, like this one:
https://datatables.net/forums/discussion/comment/163754/#Comment_163754
Kevin