convert excel date to datetime c#
Excel stores the datetime value as a serial number.
The date January 1, 1900 is treated as day 1 and all the date and time
values are calculated accordingly. Also excel saves the time
value as a fractional number from 0 to 1. So the date part
is a whole number and time is the fractional part.
When we use the Range.Value2 method to extract a date time value from excel,
it will return a double value. So we will be using [DateTime.FromOADate] function to get the date value.
Lets say we have a datetime field on the row 1 and col 1 of excel .
Following code will get the datetime value.
DateTime dateValue = DateTime.FromOADate(Convert.ToDouble((ws.Cells[1, 1] as Excel.Range).Value2));
// where ws is the Worksheet.
Are there any code examples left?
New code examples in category C#
-
C# 2022-03-27 22:40:23 c# movement script
-
C# 2022-03-27 22:15:17 Delete last modification on EntityFramework Core
-
C# 2022-03-27 22:15:02 file.create folder c#
-
C# 2022-03-27 19:25:04 Error inflating class android.support.constraint.ConstraintLayout
-
C# 2022-03-27 19:15:02 top down shooting in unity 2D
-
C# 2022-03-27 18:50:02 c# remove invalid directory characters
-
C# 2022-03-27 18:30:07 how to use K2 games Games parallax background
-
C# 2022-03-27 18:25:10 c# replace crlf
-
C# 2022-03-27 18:25:09 keycode for left mouse click unity