How to get Axlsx to write date-time strings in format "yyyy-mm-ddThh:mm:ssZ" into the excel sheet?

97 views
Skip to first unread message

ratha...@gmail.com

unread,
Jul 3, 2017, 8:42:30 PM7/3/17
to axlsx
I find that when my date-time data is a string in the form "yyyy-mm-ddThh:mm:ssZ", Axlsx writes this as a numeric value in the Excel sheet. But I need this date-time string to appear in the "yyyy-mm-ddThh:mm:ssZ" format. How do I stop Axlsx from converting this and just write the string as is?
Reply all
Reply to author
Forward
0 new messages