search

codeice / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel
0 stars 0 forks source link

DateTime does not match #108

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem? Querying an .xls spreadsheet
1.var Sched = from x in excel.WorksheetNoHeader("SheetName")
                        select x;
2.foreach(var item in sched)
    {
      string LastUpdate = item[3]
    }
3. Im reading from an .xls spreadsheet. The cell format: Category = Date and 
Type = Wednesday, March 14, 2001

What is the expected output? What do you see instead?
Wednesday, May 21, 2014      Thursday, May 21, 2014

What version of the product are you using? On what operating system?
1.8.0.0   Windows 7 Enterprise SP1

Please provide any additional information below.

Im using Visual Studio Premium 2013, Version 12

Original issue reported on code.google.com by Willie.S...@gmail.com on 22 May 2014 at 12:29