Closed GoogleCodeExporter closed 9 years ago
Can you attach the excel file that is causing the issue, and I will take a look
at it
Original comment by paulyo...@gmail.com
on 28 Apr 2010 at 3:31
Hi, I am attaching the spreadsheet I am using. I have scrubbed some data from
the
spreadsheet because it is client sensitive, but the column in question is
included.
Thanks for taking the time to investigate.
Original comment by nosnibor...@gmail.com
on 28 Apr 2010 at 3:50
Attachments:
I won't have time to look at it this week, but I will get back to you by early
next week.
Original comment by paulyo...@gmail.com
on 28 Apr 2010 at 11:20
After researching the problem it looks like the Jet OleDb driver is having
issues handling a
datetime column with the first 8 rows being null. I did find a work around
though.
You need to first return all the excel rows and convert it to a list in memory:
var rebateList = (from g in workbook.Worksheet<RebateSubmitted>("Query Results")
select g).ToList();
Then you can use a LINQ statement to query the in-memory list
var filteredRebates = from r in rebateList
where r.TaskSubmitDate > new DateTime(1997, 1, 1)
select r;
Let me know if this works for you.
Original comment by paulyo...@gmail.com
on 3 May 2010 at 8:31
Original comment by paulyo...@gmail.com
on 12 May 2010 at 5:23
Original issue reported on code.google.com by
nosnibor...@gmail.com
on 28 Apr 2010 at 12:43