Exporting to excel shows date time value as UTC time while using EPPlus
bintus20 opened this issue · 0 comments
bintus20 commented
When I am trying to export data to excel using EPPlus all DateTime values are displaying as UTC time instead of the datetime value in the output. For example: if the value is 13/11/2019 05:35:34 PM. In the exported excel sheet it is displaying as 13/11/2019 01:35:34 PM.
How come the values are automatically getting converted?
Also, I have set the format for datetime values like below:
worksheet.Column(col).Style.Numberformat.Format = "dd/MM/yyyy hh:mm:ss AM/PM";
Please help.