Insert field format into export excel.
Insert field format into export excel.
moggers
Posts: 2Questions: 2Answers: 0
I'm looking over the buttons API for datatables, particularly formatting fields when exporting to xlsx.
Is it possible to format a cell in such a way that excel will treat the field as a time interval once it is loaded in excel, rather than requiring the user to focus and unfocus the cell and get excel's autodetect to kick in?
Something like inserting excel field metadata is how I imagine it would be done.
Thanks,
Matt
This discussion has been closed.