Reading DateTime column from excel into C# app
I'm trying to read data from .xls files into C# application. One of the columns has date time data like "3/31/2004 9:57:35 AM". I 'm accessing the excel data as
System.Array myvalues = (System.Array)range.Cells.Value;
Now myvalues has the excel data excep the DateTime appears as System.Double.
what am I doing wrong.
Please help.
tia
shashank
Jignesh TrivediPosted Apr 22, 2012, 11:49 PM
Please refer,
http://www.dotnetperls.com/fromoadate
i think this will help u to resolve the probelm.
Let me know if you have any other truble.
hope this help.
Nitesh KejriwalPosted Apr 22, 2012, 9:47 PM