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

EPPlus 4.1

Rating:        Based on 10 ratings
Reviewed:  8 reviews
Downloads: 80530
Change Set: 643d411b032b
Released: Jul 14, 2016
Updated: Jul 14, 2016 by swmal
Dev status: Stable Help Icon

Recommended Download

Application EPPlus 4.1
application, 1254K, uploaded Jul 14, 2016 - 55226 downloads

Other Available Downloads

Application EPPlus 4.1 with samples
application, 1344K, uploaded Jul 14, 2016 - 16053 downloads
Application EPPlus 4.1 Documenation (Chm)
application, 5019K, uploaded Jul 14, 2016 - 9251 downloads

Release Notes

EPPlus-Create Advanced Excel spreadsheet.

EPPlus is also available via Nuget

New features in 4.0

Replaced Packaging API with DotNetZip

This will remove any problems with Isolated Storage and enable multi threading

New Cell store

  • Less memory consumtion
  • Insert columns (not on the range level)
  • Faster row inserts

Formula Parser

  • Calculates all formulas in a workbook, a worksheet or in a specified range
  • 100+ functions implemented
  • Access via Calculate methods on Workbook, Worksheet and Range objects.
  • Add custom/missing Excel functions via Workbook.FormulaParserManager.
  • Samples added to the EPPlusSamples project.

*The formula parser does not support Array Formulas
  • Intersect operator (Space)
  • References to external workbooks
  • And probably a whole lot of other stuff as well :)

*Of course the performance of the formula parser is nowhere near Excels.Our focus has been functionality.

Agile Encryption (Office 2012-)

  • Support for newer type of encryption.

Minor new features

  • Chart worksheets
  • New chart types
    • Bubble charts
    • Radar charts
    • Area charts
    • And lots of bugfixes...

Beta 2 Changes

  • Fixed bug when using RepeatColumns & RepeatRows at the same time.
  • VBA project will be left untouched if its not accessed.
  • Fixed problem with strings on save.
  • Added locks to the cellstore for access by mulitple threads.
  • Implemented Indirect function
  • Used DisplayNameAttribute to generate column headers from LoadFromCollection
  • Rewrote ExcelRangeBase.Copy function.
  • Added caching to Save ZipStream for Cells and shared strings to speed up the Save method.
  • Added Missing InsertColumn and DeleteColumn
  • Added pull request to support Date1904
  • Added pull request ExcelWorksheet.LoadFromDataReader

Release Candidare changes

  • Fixed some problems with Range.Copy Function
  • InsertColumn and Delete column didn't work in some cases
  • Chart.DisplayBlankAs had the wrong default type in Excel 2010+
  • Datavalidation list overflow cauesed corruption of the package
  • Fixed a few Calculation when refering ranges (for example If) function and some
  • Added ChartAxis.DisplayUnit
  • Fixed a bug related to shared formulas
  • Named styles faild in some cases.
  • Style.Indent got an invalid value in some cases.
  • Fixed a problem with AutofitColumns method.
  • Performance fix.
  • An a whole lot of other small fixes.

4.0.1 Fixes

  • VBA unreadable content
  • Fixed a few issues with InsertRow and DeleteRow
  • Fixed bug in Average and AverageA
  • Handling of Div/0 in functions
  • Fixed VBA CodeModule error when copying a worksheet.
  • Value decoding when reading str element for cell value.
  • Better exception when accessing a worksheet out of range in the Excelworksheets indexer.
  • Added Small and Large function to formula parser. Performance fix when encountering an unknown function.
  • Fixed handling strings in formulas
  • Calculate hanges if formula start with a parenthes.
  • Worksheet.Dimension returned an invalid range in some cases.
  • Rowheight was wrong in some cases.
  • ExcelSeries.Header had an incorrect validation check.

4.0.2 Fixes

  • Fixes a whole bunch of bugs related to the cell store (Worksheet.InsertColumn, Worksheet.InsertRow, Worksheet.DeleteColumn, Worksheet.DeleteRow, Range.Copy, Range.Clear)
  • Added functions Acos, Acosh, Asinh, Atanh, Atan, CountBlank, CountIfs, Mina, Offset, Median, Hyperlink, Rept
  • Fix for reading Excel comment content from the t-element.
  • Fix to make Range.LoadFromCollection work better with inheritance
  • And lots of other small fixes



4.0.5 Fixes

  • Switched to Visual Studio 2015 for code and sample projects.
  • Added LineColor, MarkerSize, LineWidth and MarkerLineColor properties to line charts
  • Added LineEnd properties to shapes
  • Added functions Value, DateValue, TimeValue
  • Removed WPF depedency.
  • And fixed a lot of issues. See for more details


  • Added functions Rank, Rank.eq, Rank.avg and Search
  • Custom function compilers can now be added via FormulaParserManager
  • Applied a whole bunch of pull requests (Thanks to everyone in the Community that has contributed)...
    • Performance and memory usage tweeks
    • Ability to set and retrieve 'custom' extended application propeties.
    • Added style QuotePrefix
    • Added support for MajorTimeUnit and MinorTimeUnit to chart axes
    • Added GapWidth Property to BarChart and Gapwidth.
    • Added Fill and Border properties to ChartSerie.
    • Added support for MajorTimeUnit and MinorTimeUnit to chart axes
    • Insert/delete row/column now shifts named ranges, comments, tables and pivottables.
  • And fixed a lot of issues. See for more details

Reviews for this release

Despite a tiny bug, I found this library brilliant. It's easy and so far perf are amazing. at last something open source to help forget interop for good
by kilren on Jul 26, 2016 at 4:01 PM
I can't express enough my appreciation for this library. With this library I was able to take tasks that used to take two people a whole day to do manually and automate it so no one ever has to touch those processes ever again. My only wish is, while I can code this myself (and have) I would LOVE to have grouping subtotals functions like in Excel.
by ByerRA on Jan 26, 2017 at 12:30 PM
A masterpiece
by EvilDr on Jul 21, 2016 at 12:13 PM
Great. Good project!!
by myulgong on Nov 27, 2017 at 3:42 PM
Fast, easy to create and format Excelsheets and great samples. AND it don't create any zombie excel processes. It's also faster then anything else. Really, really great. Thanks for contributing this Lib to the Open Source Community.
by mp3tobi on Mar 15, 2017 at 11:38 AM
Great job mate, allowed me to get an otherwise complex task done in just a few hours.
by gtaylor44 on Nov 12, 2016 at 5:12 PM
Fast and intuitive, it lets you write a very clean and readable code.
by RaffaeleTurra on Sep 16, 2016 at 2:59 PM
Trivial to create even the most complex excel sheets and charts. amazing library!
by octonaut on Aug 26, 2016 at 10:32 PM