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.
The next Bitslingers event will be on Monday, March April 6th. Once again we’ll host the event at the Panera Bread on Mason Montgomery road. If anyone has a better place in mind that can offer non-stop wi-fi, please let me know.
What is Bitsligners? This is an informal meetup of people interested in learning from one another. Bring your laptop and pair up with someone to work on an open source project, learn a new technique, or even dabble in a new language.
The Registration for the Central Ohio Day of .NET 2009 is now open! We will be posting the session list within the next few days, but you can get your spot in line now.
REGISTER
Blog about it! Tweet about it! Share the url with your developer friends: http://tinyurl.com/cododn09
After you register, head over to the CODODN 2009 official web site and get some Bling for your blog or home page.