SimpleExcelExport it is a small library to export to excel(using NPOI) a list of objects in your program, in order to add export capabilities to your application in a short time.
I already using in some projects, and maybe you can give a try if have a lot of modules where you need to exporte some data to excel.
Soon i will to upload in nuget for a easy install.
##Install With nuget:
- Install-Package SimpleExcelExport
(https://nuget.org/packages/SimpleExcelExport)
##Dependencies:
- NPOI
##How to use
-
Add the reference in your project.
-
Create a list of object an populate.
var persons = new List<Person>(); -
Pass the list to SimpleExcelExport:
var result = SimpleExcelExport.ExportToExcel().ListToExcel(persons);
-
(Optional) return file from web controller:
return File(result, "application/vnd.ms-excel", "Report.xls");
-
The library return the generated excel as a byte array.
##Column names and columns order The columns names and order by default are the property name and alphabetical order, if you want to set a custom name for the columns and order, you need to add an attribute to your properties in your POCO class, for example:
[ExcelExport("Last Name", order = 2,HFontBold=true,HFontColor ="White",HBackColor="Red")]
public string LastName { get; set; }
[ExcelExport("day of birth", order = 3)]
public DateTime BirthDay { get; set; }
Where you set the column name with the first parameter and the column order with the named parameter "order". Also(thanks to @rivuc) you can define font weight(bold), cell background color and font(foreground) color.
Any comment or idea for a new feature(or even better to send a pull request) contact me at: twitter: @majimenezp