Monday, July 18, 2011

LINQ to XlsX... Using VB.Net, LINQ, the OpenXML SDK and a little C# helper, to query an Excel XlsX

OpenXML Developer - Query Open XML Spreadsheets in VB.NET using LINQ

"When working with SpreadsheetML, one of the most common needs is to retrieve the data from a worksheet or a table in as easy a fashion as possible. There has been a fair amount written for C# developers to do this, but not nearly as much for VB.NET. Some time ago, I wrote a blog post, Using LINQ to Query Excel Tables, which introduced a few C# classes and extension methods that make it easy to query SpreadsheetML. This post presents a super-easy way to use that code from VB.NET.

To make it as easy as possible to get going using LINQ with VB to access SpreadsheetML, I've recorded the following screen-cast that walks through the process of building a VB.NET application that uses the code from that blog post. Here is the video:

...

SNAGHTML1e8894fe

...

SNAGHTML1e88582d

..."

Nice example code and video that I've not seen elsewhere...

No comments:

Post a Comment

NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...

ALL comments are moderated. I will review every comment before it will appear on the blog.

Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...

I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...

Please see my comment policy for more information if you are interested.

Thanks,
Greg

PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...