I’m sure you’ve all had to export to Excel at one point or another. I created a small wrapper around the EPPlus library for MVC. Basically my wrapper contains a few helpers for common formatting, an ActionResult, and a column definition. Here’s what the end result looks like in the simplest form:
public ActionResult ExportToExcel() Basically this exports all the columns and records in the SampleInfo collection. So if you want to specify the columns you want, you can do this:
public ActionResult ExportToExcel() The ExcelColumnDefinition.Create<> is kinda ugly, so you could create a small helper method for readability like this:
private static ExcelColumnDefinition Column(Expression<Func<SampleInfo, object>> member, string format = null, string header = null) Now the above example looks like this:
public ActionResult ExportToExcel() So this is what the ExcelColumnDefinition looks like:
public class ExcelColumnDefinition Here’s the actual ActionResult:
public class ExcelFileResult<T> : ActionResult So that’s it. If you have any questions, please feel free to comment below.
You can browse or download the source on GitHub. The sample project has examples.
