EPPlus 3.1

Rating:        Based on 28 ratings
Reviewed:  25 reviews
Downloads: 45064
Change Set: d09aa5eaced9
Released: Apr 11, 2012
Updated: Apr 11, 2013 by JanKallman
Dev status: Stable Help Icon

Recommended Download

Application EPPlus 3.1.3 Binary
application, 296K, uploaded Apr 11 - 26675 downloads

Other Available Downloads

Application EPPlus 3.1.3 Samples Including Binary
application, 366K, uploaded Apr 11 - 11045 downloads
Documentation EPPlus 3.1 Documentation (chm-file)
documentation, 3757K, uploaded Sep 25, 2012 - 7344 downloads

Release Notes

EPPlus-Create advanced Excel 2010 spreadsheets

This version contain version contains two new major features - VBA and conditional formatting

New features

VBA

  • Create,read and write a VBA project from scratch or in a template.
  • Add and modify modules and classes.
  • Read and write code to documents(workbook and worksheets), modules and classes.
  • VBA protection
  • Code signing
  • And more...

Conditional Formatting

  • Apply conditional formatting on any range of cells.
  • Choose between more than 40 different types ("beginsWith", "between", "containsText", "endsWith", "equal", "greaterThan", "greaterThanOrEqual", "iconSet3", "iconSet4", "iconSet5", "last7Days", "lastMonth" and many more)

Minor new features

  • Picture Hyperlinks
  • Chart Axis Titles
  • Remove method added to Drawings collection

An a lot of bug fixes.
3.1.2 changes
  • Fixes problem with messed up Normal style if the Normal style is not the first saved Style in the NamedStyles collection.
  • Fixed problem with CellIs in templates (14750, 14749).Turned off dtd on XmlDocument.Load / LoadXml to avoid Xml-bombs. Fixed pivottable constructor that set default values in templates(14723).
  • Fixes problem with indexed colors in conditional formatting.
  • Fixes full row / column ranges with defined names (throwing exception when accessing Start and End properties).
3.1.3 changes
  • Fixed VBA project corruption when adding a new worksheet.
  • Fixed Drawing resizing with hidden rows.
  • Fixed problem with named styles and blank text property on range when it shold be "0"
  • Fixes issue 14768-Missing Normal style causes corruption of xfs styles.
  • Fixed issue 14799-Table-StyleName bug.
  • Fixed issue 14799-Change of contenttype from xlsx to xlsm and pivottable caused corruption
  • Fixed issue 14795-Scatterchart smooth lines.
  • Fixed issue 14809-Namedstyles was invalid when loading from a template
  • Fixed issue 14805-LoadFromText did not work with a null argument for parameter Text)
  • Fixed issue 14819-Setting data validations default operator to Any.
  • Fixed issue 14823-Invalid hyperlinks when uri was encoded.
  • Fixed issue 14818-attribute createdVersion of the Pivottable was set to 1 and causing the pivottable ignore the enableDrill and showDrill attributes
  • Fixed issue 14803-Duplicate column names when creating a table caused a corrupt workbook.
  • Fixed issue 14820-Invalid sort order on header footer elements when creating from a template. Added reference to System.Web for Uri decoding

Reviews for this release

     
Two words. Frickin' awesome !!
by Moonglum on Jun 1 at 4:27 PM
     
Simple and elegant. Added export button to MVC 4 web app in 30 minutes including ramp up time. EF -> Linq -> ActionController -> Excel in 11 lines of code. Fantastic!
by joelmcconaughy on May 24 at 2:52 PM
     
Great library with a lot of features and good performance.
by Tridus on May 22 at 5:37 PM
     
Absolutely top notch library. Exposes almost all Excel functionality without having office installed and is very quick and easy to use.
by danielkennedy on May 15 at 10:31 AM
     
Excelent tool for export to excel. Very fast.
by ngoxuanthuan on May 10 at 3:16 PM
     
Excellent tool for editing/creating OpenOffice Excel documents.
by medelbrock on May 2 at 2:27 PM
     
Light-weight, easy to work with and seemingly comprehensive Excel export. Way to go!
by liorshapira on May 1 at 10:26 PM
     
Excellent job, this is a great solution for a very common problem. Successfully deployed on an intranet solution that required the generation of Excel docs in the App server. We got excellent productivity and the performance was good. Thanks very much and really recommend it to anyone.
by ealbert on Apr 15 at 8:58 PM
     
Finally replaced some Excel Interop COM code with this library. This is so much faster and no Excel.exe processes. Thanks!
by jonathanray on Apr 11 at 9:47 PM
     
This project is a blessing for my development! If you have a need for XLSX reporting this is the way to go. I hope it is kept up to date.
by CanManXtra on Apr 1 at 3:59 PM
     
Great plugin! I don't want to use MS Interop in my software because some of my clients use Open Office, Libre Office, etc. MS Interop is completely useless when the target PCs don't have MS installed. I had lot of headaches, trying to write my own code to create xlsx file programmatically, until I found this. It's fast. It's trustworthy. It works. It's free. Thank you. I can't thank you enough.
by danielwilianto on Mar 1 at 1:11 AM
     
Conditional formatting, print areas, XLSX support, only 600k... best of the bunch. Cheers!
by Dunc_ on Feb 28 at 2:28 PM
     
Great Library! Not having to install office or use Interop to create Excel files is nothing short of bloody awesome! :)
by MitchWheat on Feb 13 at 6:59 AM
     
I have been trying to manually code what this package entails, so I know is loads of work. Essentially, you do not usually get all the functionality you require. Been coding with it for about <1hr and got my export and functionality right, thusfar no problems and easy to use and code with. Thank you for the hard work, much appreciated.
by caj on Feb 3 at 8:29 PM
     
Excellent package worked very well for my application (Converting the output of SQL Report Service from XML to XMLS to bypass 64k barrier). Could use more documentation.
by smorley on Jan 23 at 7:08 PM
     
Excellent library! We've worked with file handing for many years using libraries such as Aspose and SpreadsheetGear and I can honestly say this library is up there with the best of them. We had a requirement to do an export from a datatable to Excel 2007 and we had this up and running in < 1hr. My only complaint is that it was hard to find. Where do I donate?
by marklalor on Jan 9 at 9:12 PM
     
Great library! Thank you!
by DeadOrc on Jan 7 at 12:35 PM
     
Fantastic Excel library, packed with features but still small enough to include in your project...
by netizenk on Dec 17, 2012 at 7:33 PM
     
Reading old Excel xls files is very tedious at best and not a good use of a programmers' time. I had working code in less than 1 hour after downloading EPPlus, open an xlsx, find a named sheet, use linq to find data, and then update the workbook. Flawless and very fast performance. I will no longer dread working with Excel. (VS 2008, .net 3.5) Thank you for publishing this fantastic library !!
by Zaon_pig on Nov 21, 2012 at 3:10 PM
     
sound good, have had been stuck in Excel Automation too long till the day I got this...
by hoang_nguyenhuu on Nov 20, 2012 at 4:26 PM
     
Very useful using it with ASP.NET
by l2mt on Nov 3, 2012 at 7:12 PM
     
not compatible with wps. a famous spreadsheet software in china.
by huangxianggui on Oct 21, 2012 at 6:03 AM
     
Very easy to use. I was up and running in very little time. Thank you!
by DougJacobson on Oct 11, 2012 at 6:40 AM
     
Excellent library. I am editing some existing templates and building fairly complex Excel worksheets from scratch including charts, formatting and pivot tables. The documentation, samples and discussion is active and very good. Most of my spreadsheets have thousands of rows, and the performance has been very good. Thanks to the team for your fantastic work!
by CellBent on Sep 27, 2012 at 11:29 AM
     
Great library, great example. I started working with EPPlus 2 weeks ago and it makes me feel good that you're still working on the project. Keep on the good work!
by Wegginho on Sep 27, 2012 at 7:25 AM