7
Shouts

Reading an Excel spreadsheet into dynamic objects - .NET Development - Gal Ratner

published 432 days, 23 hours, 51 minutes ago posted by galratnergalratner 433 days, 12 hours, 21 minutes ago
Friday, March 18, 2011 3:14:29 PM GMT Friday, March 18, 2011 2:44:50 AM GMT

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. This is our spreadsheet:

In order to read and parse the Spreadsheet we are going to use The Open XML SDK 2.0 for Microsoft Office availab...

category: Architecture | clicked: 6 | | source: galratner.com | show counter code
tags: C#, Open XML Format SDK

1 comment posted.

To post your comment please login or signup