{"id":3184,"date":"2016-03-20T05:29:49","date_gmt":"2016-03-20T05:29:49","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?page_id=3184"},"modified":"2016-03-20T09:50:45","modified_gmt":"2016-03-20T09:50:45","slug":"query-open-xml-spreadsheets-in-vb-net-using-linq","status":"publish","type":"page","link":"https:\/\/www.ericwhite.com\/blog\/query-open-xml-spreadsheets-in-vb-net-using-linq\/","title":{"rendered":"Query Open XML Spreadsheets in VB.NET using LINQ"},"content":{"rendered":"

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<\/a>, 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.<\/p>\n

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:<\/p>\n