How can you set column format when exporting to excel?
Posted 2 years ago
by BlazorRazor
I've scoured the entire internet, to no avail.
I want to change my date column to be formatted as "date" in excel.
The "format" in my gridcolumn is for modifying the data in my DB. (Picture 1) https://postimg.cc/gnZrF22s
However when I export my table, the date is formatted as a general text. (Picture 2) https://postimg.cc/jwc3jTqk
I would like the column to appear formatted like this in excel. (Picture 3) https://postimg.cc/3Wb9fnkp
I've already tried changing the format type in the gridcolumn but it didnt change anything in excel.
Any ideas?
Someone is typing...
Post a Reply
You must be logged in to add a new post.
Number of online users: 2