How can you set column format when exporting to excel?

Posted 2 years ago by BlazorRazor
0

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
An error has occurred. This application may no longer respond until reloaded. Reload 🗙