Dexiom.EPPlusExporter
Download & Install
Install-Package Dexiom.EPPlusExporter
Wiki
Please review the Wiki pages on how to use Dexiom.EPPlusExporter.
Quick Usage Preview
Basic example
Let's say you want to dump an array or a list of objects to Excel (without any specific formatting).
This is what you would do:
//create the exporter
var exporter = EnumerableExporter.Create(employees);
//generate the document
var excelPackage = exporter.CreateExcelPackage();
//save the document
excelPackage.SaveAs(new FileInfo("C:\\example1.xlsx")); Quick Customizations (using fluent interface)
Quick customization can be accomplished by using the fluent interface like this:
var excelPackage = EnumerableExporter.Create(employees)
.DefaultNumberFormat(typeof(DateTime), "yyyy-MM-dd") //set a default format for all DateTime columns
.NumberFormatFor(n => n.DateOfBirth, "yyyy-MMM-dd") //set a specific format for the "DateOfBirth"
.Ignore(n => new { n.UserName, n.Email }) //remove 2 columns from the output
.TextFormatFor(n => n.Phone, "Cell: {0}") //add a prefix to the value
.StyleFor(n => n.DateContractEnd, style =>
{
style.Fill.Gradient.Color1.SetColor(Color.Yellow);
style.Fill.Gradient.Color2.SetColor(Color.Green);
}) //the cells in this columns now have a gradiant background
.CreateExcelPackage();- Available customizations:
- Ignore is used to skip a column when generating the document
- DefaultNumberFormat is used to specify a default display format for a specific type
- NumberFormatFor is used to set a specific format (just like you would using Excel)
- TextFormatFor is used to convert a value to text
- StyleFor is used to alter the style for a specific column
License
Copyright (c) Consultation Dexiom. All rights reserved.
Licensed under the MIT License.