Reading an Excel spreadsheet into dynamic objects

added by galratner
3/17/2011 9:44:09 PM

0 Kicks, 141 Views

Excel represents documents using Office Open XML (OOXML), a zipped XML based format developed for spreadsheet and chart representation. In this article I am going to demonstrate parsing an Excel spreadsheet and loading the data into a generic List. OOXML was incorporated into Office in 2007 therefore the following code will not work with older versions of Excel.