Geeks With Blogs
CodeSpeaker A .NET developers blog October 2009 Entries
Using Linq with Excel sheets
Based on a few examples i found when googling the web, i made a class that can help you query excel sheets in a very simple way with plain vanilla .NET code. Our example file contains one sheet with the name "Sheet1", listing a few employees. Id FirstName LastName Age 1 John Doe 35 2 Bob Smith 42 3 Charlie Smith 40 4 Steve Rights 29 5 Bill Abrams 24 Now lets say that you would like to read all employees from this sheet into an anonymous type list and order the result by age. The following console-application ......

Posted On Sunday, October 4, 2009 12:48 PM

Copyright © CodeSpeaker | Powered by: