JanKallman/EPPlus

Exporting to excel shows date time value as UTC time while using EPPlus

bintus20 opened this issue · 0 comments

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.