Skip to content
This repository was archived by the owner on Mar 9, 2020. It is now read-only.
This repository was 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

@bintus20

Description

@bintus20

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions