This project has moved and is read-only. For the latest updates, please go here.


Rating:        Based on 12 ratings
Reviewed:  10 reviews
Downloads: 21444
Change Set: 78522
Released: May 31, 2011
Updated: May 31, 2011 by JanKallman
Dev status: Stable Help Icon

Recommended Download

Application EPPlus Binary
application, 197K, uploaded May 31, 2011 - 11018 downloads

Other Available Downloads

Example EPPlus Sample Including Binary
example, 257K, uploaded May 31, 2011 - 5620 downloads
Documentation EPPlus documentation (chm-file)
documentation, 2317K, uploaded May 31, 2011 - 4806 downloads

Release Notes

EPPlus-Create advanced Excel 2007 spreadsheets on the server

This version has been updated to .Net Framework 3.5

New Features

  • Data Validation.
  • PivotTables (Basic functionalliy...)
    • Support for worksheet data sources.
    • Column, Row, Page and Data fields.
    • Date and Numeric grouping
    • Build in styles.
    • ...and more

And some minor new features...
  • Ranges
    • Text-Property|Get the formated value
    • AutofitColumns-method to set the column width from the content of the range
    • LoadFromCollection-method to Load data from an IEnumerable
    • GetValue<T> method to get the typed value from a cell
  • Column
    • Autofit-method to set the column width from the content.
  • Worksheet
    • TabColor property
    • GetValue<T> method to Get the typed value from a cell (this simplify the handling DateTime, Timestamp and some other datatypes)
    • SetValue method to set the value of a cell.
    • MoveAfter, MoveBefore, MoveToStart and MoveToEnd methods (Thanks to Jim Sully)
  • Charts
    • Trendline support
    • Pivotcharts
    • RightAngleAxes, DepthPercent and HeightPercent added to ExcelView3D
    • DisplayBlanksAs and ShowHiddenData properties added to ExcelChart
  • ...and a lot of bugfixes

Reviews for this release

Good library, shame its GPL
by gatapia on Jan 4, 2012 at 2:49 AM
Nice but needs polish. As another reviewer mentioned, the ExcelWorksheet class supports row insertion/deletion but not column insertion/deletion. There also seems to be no equivalent of cell.End[XlDirection.xlDown] and cell.End[XlDirection.xlToRight], which allow you to find the last contiguous cell.
by danthman on Nov 5, 2011 at 2:34 AM
In the category of free libraries for editing .xlsx excel files i've found, I think it's the best. Support for pivot tables it's ok.
by dhernandez on Nov 2, 2011 at 11:51 AM
Quite fast, but missing basic functionality such as inserting columns into worksheets
by amwild on Oct 27, 2011 at 4:20 AM
I really love this project! I also think that LGPL suites better on this project in order to use it on commercial projects!
by ikaragkiozoglou on Oct 20, 2011 at 5:07 PM
Appears very intuitive to use. Great samples. Fantastic work!
by PatrickF on Oct 10, 2011 at 2:14 PM
This works great for me. I wanted to create a generic function for exporting data from a SQL data source to an XLSX file in ASP .NET and didn't want to write my own. It was really simple to do using EPPlus along with the sample code for using it in a web application. Great job!
by rslygh on Sep 20, 2011 at 4:16 PM
Thank goodness for this project!
by AaronLS on Aug 31, 2011 at 5:56 PM
Great Library, but should be under LGPL because GPL is unusable.
by eisiWare on Aug 10, 2011 at 12:58 PM
I wanted to spead up writing around 200 Excel Sheets with 1000*10 cells. The speed with this package was 23 times faster than using the PIA. I also needed less than an hour for switching to the library from PIA, so it was really almost seemless.
by weismat on Jul 6, 2011 at 6:35 AM