Skip to content
This repository has been archived by the owner on Mar 9, 2020. It is now read-only.

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

Open
bintus20 opened this issue Jan 10, 2020 · 0 comments
Open

Comments

@bintus20
Copy link

bintus20 commented Jan 10, 2020

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant