How do I read data from a spreadsheet using the OpenXML Format SDK?

Question

I need to read data from a single worksheet in an Excel 2007 workbook using the Open XML SDK 2.0. I have spent a lot of time searching for basic guidelines to doing this, but I have only found help on creating spreadsheets.

How do I iterate rows in a worksheet and then iterate the cells in each row, using this SDK?

Answer 1

The way I do this is with Linq. There are lots of sample around on this subject from using the SDK to just going with pure Open XML (no SDK). Take a look at:

• Office Open XML Formats: Retrieving Excel 2007 Cell Values (uses pure OpenXML, not SDK, but the concepts are really close)
• Using LINQ to Query Tables in Excel 2007 (uses Open XML SDK, assumes ListObject)
• Reading Data from SpreadsheetML (probably best "overall introduction" article)