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.