Importing Excel Data to a Generic List Using Open XML SDK and Object Model Mapping

Shenwei Liu

Rate me:

5.00/5 (7 votes)

5 Jun 2014CPOL9 min read

65.4K

2.9K

C# class that populates a generic list with data retrieved from Excel data file

In this article, I will be presenting and explaining an Open XML SDK Library based ExcelReader class for importing Excel data to a generic list through the object model mapping.

ExcelToGenericList.zip
- ExcelToGenericList
  - App.config
  - Classes
    - ExcelReader.cs
    - GenericListOutput.cs
  - ExcelToGenericList.csproj
  - ExcelToGenericList.sln
  - lib
    - DocumentFormat.OpenXml.dll
    - WindowsBase.dll
  - Models
    - Product.cs
  - Program.cs
  - Properties
  - TestProducts.xlsx
ExcelToGenericList-noexe.zip
- App.config
- ExcelReader.cs
- GenericListOutput.cs
- ExcelToGenericList.csproj
- ExcelToGenericList.sln
- Product.cs
- Program.cs
- AssemblyInfo.cs
- Resources.Designer.cs
- Resources.resx
- TestProducts.xlsx

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Shenwei Liu

United States

Shenwei is a software developer and architect, and has been working on business applications using Microsoft and Oracle technologies since 1996. He obtained Microsoft Certified Systems Engineer (MCSE) in 1998 and Microsoft Certified Solution Developer (MCSD) in 1999. He has experience in ASP.NET, C#, Visual Basic, Windows and Web Services, Silverlight, WPF, JavaScript/AJAX, HTML, SQL Server, and Oracle.

Importing Excel Data to a Generic List Using Open XML SDK and Object Model Mapping

License

Comments and Discussions