How do I read data from a spreadsheet using the OpenXML Format SDK?
- by ProfK
I need to read data from a single WorkSheet in an Excel 2007 WorkBook using the OpenXML Format SDK v2.0. I have spent some not insignificant 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?