I am using the Datatables TableTools plugin in order to provide an Export to Excel option for a table on my page.
In general everything works as intended.
My only issue is that I would need all the data resp. the columns in the resulting Excel table being formatted as text as otherwise I am losing data in some columns.
- I have a column that has leading zeros (e.g.
TableTools does not create a real
excel file, it creates a
csv file instead. Those contain only raw data, no formatting. Although the leading zeros are there, Excel usually will not show them. You have several options here:
csvfile from Excel's open dialog, from which you should be able to mark columns as text (you might need to change the file type to