Using the open xml format sdk 2.0 version | social.msdn.microsoft.com

Using the open xml format sdk 2.0 version | social.msdn.microsoft.com.

Here's a quickie on navigating to a cell in an Excel 2007 XML document, using the Open XML Format SDK verison 2.0 released recently...

Using LINQ to Query Tables in Excel 2007 | MSDN

Using LINQ to Query Tables in Excel 2007

Microsoft LINQ allows for database style queries against object data. Although you cannot run LINQ queries directly against data stored in Microsoft Office Excel 2007 workbooks, it is possible to load the data into objects that do support LINQ.

This Visual How To illustrates how to use the Open XML Formats to load information stored in Excel worksheets into generic lists that support LINQ.

This Visual How To uses the Open XML Format SDK 2.0, which you need to install before you begin.