Click here to Skip to main content
15,746,534 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am using openxml to read excel sheets. There i have some columns of datetime type. But when I read date column it shows me value converted in some other format that is not detectable as datetime. Can anybody help me in detecting datetime column, when reading excel file using open xml?

Big Thanks.

Excel dates and times are stored as floating point values where the integer portion is the number of days since the epoch, and the decimal portion is the number of seconds past midnight. See this link[^] (and many others) for details.
Share this answer
See This link i will helpful for you
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900