EPPlus 4.0.1

Rating:        Based on 10 ratings
Reviewed:  10 reviews
Downloads: 9764
Change Set: d965a56577ba
Released: Nov 30, 2014
Updated: Dec 1, 2014 by swmal
Dev status: Stable Help Icon

Recommended Download

Application EPPlus 4.0.1
application, 585K, uploaded Nov 30 - 5714 downloads

Other Available Downloads

Example EPPlus 4.0.1 with sample
example, 675K, uploaded Nov 30 - 3457 downloads
Documentation EPPlus 4.0 Documenation (Chm)
documentation, 5588K, uploaded Nov 30 - 593 downloads

Release Notes

EPPlus-Create Advanced Excel spreadsheet.

EPPlus is also available via Nuget

New features

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
    • Bubblecharts
    • 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 Candidate 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 caused corruption of the package
  • Fixed a few calculation bugs, when refering ranges (for example in the If function)
  • 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.

Reviews for this release

This tools works very well for our application. With 3.1 we were hanging when generating big spreadsheets. With 4.0 Beta this is no longer the case. We hope this release will go live very soon.
by rdtOregon on Jun 20 at 6:29 PM
I have been using EPPlus for creating large excel sheets. I find that version 4.x is much faster and less memory consumption than version 3.x. I hope the final version of 4 will be released some time soon :)
by ikyriakidis on Apr 22 at 1:53 PM
Updated the library on an existing script with no modifications. The script used to take several hours and with the beta version finished in 2 minutes.
by Tom_Z on Apr 3 at 7:06 PM
I was getting the System.IO.IsolatedStorage.IsolatedStorageException error on one of the 500 files I was generating, but Version 4.0 beta solved the problem. The only issue I see so far is that "column autofit" does not appear to be working as well as it did in version 3.1.
by JoeThePimpernel on Apr 3 at 1:40 PM
I am facing one problem with this version. When I am using the excel range base like this: ws.Cells[2, i + 1, rowCount + 1, i + 1] it give me the range but remove the empty columns. Please review this issue I need this as soon as possible.
by harshkaushal on Dec 4 at 3:52 AM
When I want to add data table to existing sheet in excel, I am getting "An item with the same key has already been added." error in this version. But In verison 3.1, it was OK.
by benjcev on Nov 7 at 8:32 AM
The beta 2 release fixed the problem with "Unable to create mutex. (Exception from HRESULT: 0x80131464)" we were having with 3.1. Looks good to me!
by hawkeye3677 on Nov 6 at 5:19 PM
The tool works very well , expect that we are not able to successfully fire VLOOKUPs existing in the workbook. Our use case requires us to change cells in a predefined workbook and fire a formula refresh. The users have defined VLOOKUPs and we get back #VALUE as result for the lookups.
by PralayAhluwalia on Aug 25 at 10:19 AM
such a great library! Thank you!
by Xenolith on Aug 14 at 10:19 AM
I've done a simple test of inserting about 6 million records in a single worksheet. (150000 rows by 50 columns). Ver 4.0 had memory consumption of about 450MB and needed 288 sec to build and save the test case. Ver 3.1 had memory consumption of about 1100MB and it took 174 sec to build and save the test case. So, huge improvment on memory utilisation, and worse performance in the packaging stage.
by aKocen on Mar 26 at 8:50 AM