how to format a column with excelHtml5?
how to format a column with excelHtml5?
andres_ontiveros
Posts: 2Questions: 1Answers: 1
Hi, I would like to know if I can format a column in .xlsx text only, I am new to this kind of thing. What happens is that a column that has serial numbers and the last digits are set to 0 because they are numbers (Image attached).
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
get the result I needed with this https://datatables.net/extensions/buttons/examples/html5/outputFormat-function.html
When I was looking to format dates for Excel I again and again found this post, hence I would like to leave also a hint for how to format dates: https://datatables.net/forums/discussion/50616/what-is-the-correct-format-to-export-dates-with-html5-to-excel