Cool find – Simple LINQ to Excel Provider

Tonight I was working with an Excel document a colleague sent me and I needed to pull out the data into an XML document with a specific format.  I found myself thinking, I wonder if there is a LINQ to Excel provider yet.  A quick search found that indeed someone had thrown together a LINQ provider for Excel. 

It’s not bullet proof by any means, and I did have to do some tweaking of the provided code to handle some empty cells and such, but within a few minutes I was using LINQ to Excel to map the contents of a sheet into a collection of classes, and then LINQ to XML to create a document.  Pretty slick stuff.  Thanks K. Jacobson for the jump start.