Releases: chsword/Excel2Object
Releases · chsword/Excel2Object
2.0.0.122
2.0.0.113
2.0.0.105
1.0.0.91
1.0.0.80
1.0.0.43
1.0.0.32
1.0.0.26
v1.0.0.14
Excel convert to .NET Object
NuGet Install
PM> Install-Package Chsword.Excel2ObjectDemo Code
Model
public class ReportModel
{
[Excel("标题",Order=1)]
public string Title { get; set; }
[Excel("用户",Order=2)]
public string Name { get; set; }
}Model List
var models = new List<ReportModel>
{
new ReportModel{Name="a",Title="b"},
new ReportModel{Name="c",Title="d"},
new ReportModel{Name="f",Title="e"}
};Convert Object to Excel file.
var exporter = new ExcelExporter();
var bytes = exporter.ObjectToExcelBytes(models);
File.WriteAllBytes("C:\\demo.xls", bytes);Convert Excel file to Object
var importer = new ExcelImporter();
IEnumerable<ReportModel> result = importer.ExcelToObject<ReportModel>("c:\\demo.xls");With ASP.NET MVC
In ASP.NET MVC Model, DisplayAttribute can be supported like ExcelAttribute.
Document
http://www.cnblogs.com/chsword/p/excel2object.html