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

EPPlus 3.1

Rating:        Based on 70 ratings
Reviewed:  58 reviews
Downloads: 134748
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, 2013 - 83826 downloads

Other Available Downloads

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

Release Notes

EPPlus-Create advanced Excel 2010 spreadsheets

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

New features


  • 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

I have error - worksheet.Cells["A1"].LoadFromDataTable((DataTable)datagridview.DataSource, true); about 800.000 rows.
by abaca on Nov 21, 2014 at 7:24 AM
Excellent library! Thanks so much guys for creating and maintaining such a useful tool, worked great for our macro-enabled workbook requirement.
by beto87 on Nov 19, 2014 at 4:53 PM
The library works great! Super easy to use for exporting lists of data to Excel 2007/2010 format spreadsheets!
by crpietschmann on Nov 11, 2014 at 9:03 PM
Great library. A few bugs could have been ironed out, thankfully community members have provided workarounds.
by IndexOverflow on Nov 5, 2014 at 1:42 PM
One of the most best dll that I used
by Dokko on Nov 2, 2014 at 1:40 AM
Incredible fast and powerfull.
by r3dh4 on Oct 6, 2014 at 10:05 AM
Thanks. Excellent lib and very intuitive to use.
by dmytrodovgan on Aug 11, 2014 at 2:37 PM
I like it a lot! No saving issues
by johannesv on Jun 27, 2014 at 8:46 AM
Very impressed with this. Very powerful for report generation. Just don't let on to others how easy it is to accomplish pretty complex reports. Be sure to download the examples. I didn't need documentation because the samples were so thorough. Great work!!
by gslysz on May 22, 2014 at 6:36 PM
Currently using 3.1 to implement a big batch of different reports. Like everyone says, it's a brilliant piece of work and makes your life a lot easier. The users of the reports I'm implementing are already commenting on how much faster they generate over previous reports implemented with Interop.Excel.
by wrummler on May 21, 2014 at 8:35 PM
Very excellent tool! Expect to improve the performance!
by MingleLui on May 6, 2014 at 3:32 AM
Creating a sheet from a datatable or collection and easily setting up a pivot table sheet based on that data makes this library a crown jewel for the enterprise.
by pwizzle on Apr 26, 2014 at 4:27 AM
saved me a ton of time, worked like a charm, love it! thanks!
by jasonjef on Apr 22, 2014 at 6:40 PM
This library just saved me so much work. Documentation needs to be a little bit more thorough, but the library itself... oh... I can't thank the developers enough. Had to have this project done by today and I had just a few hours left. Found this, was able to create a workbook with several sheets and thousands of records. Simply brilliant.
by bkboggy on Mar 28, 2014 at 10:07 AM
Very intuitive to use, especially for those devs who does not want to export data via DataTable but want a precious control of the raw data.
by hunterwei on Mar 18, 2014 at 1:06 AM
Excellent - Thank you!
by dcarlson on Mar 6, 2014 at 3:48 AM
Thanks for sharing! It works like a charm!
by sathiam on Feb 28, 2014 at 9:13 AM
I am really glad somebody made something like this. Thanks a lot
by inormis on Feb 21, 2014 at 2:17 PM
This library makes my job easier.
by PrincessLenLen on Feb 9, 2014 at 6:24 AM
Excellent! The most simple and easy solution for creating excel files
by Vicrodg on Jan 6, 2014 at 7:58 PM
Thank you for this great package ! Sadly, I can't use it for my current project because the support for Tables doesn't meet my needs, but everything else works just fine.
by ZipionLive on Jan 6, 2014 at 11:22 AM
very thank you
by JeonSangHoon on Jan 6, 2014 at 3:36 AM
Excellent lib! Help me a lot with my web app.
by berghallen on Jan 3, 2014 at 1:14 PM
EPPlus is really great. Thank you very much.
by debopampal on Nov 11, 2013 at 2:35 AM
EPPlus is really great, thanks for that !
by abakula on Sep 30, 2013 at 11:53 PM
Works great even when a ton of records (5MB+) are being exported to excel and pushed to user. Unlike ClosedXML there are no Memory streams involved wile writing response to user and therefore no out of memory exceptions. Export to Excel is much cleaner and faster, Thanks Jan Kallman!
by Anusha12 on Sep 30, 2013 at 6:01 PM
Great library when you have simple things to do quickly. For complex operations (like inserting rows keeping style without breaking excel final document), it can be really tricky to know how to make it in a simple way, and the (lack of) documentation doesn't really help...
by jdemoux on Sep 25, 2013 at 4:46 AM
Simple and Easy use DLL. Very Nice
by balakri on Sep 10, 2013 at 12:12 PM
Nothing to say. Works like a charm. Really nice and simple to use.
by pjaaar on Aug 29, 2013 at 10:21 AM
This DLL is really good ! Now I can make Excel XSLX with Powershell without Microsoft Excel...
by Avalon77 on Aug 1, 2013 at 9:12 AM
Great library! Good documentation available to create a very nice and clean excel export! All functionality you could need is included: functions in cells, text formatting, text and cell layout, cells that span multiple rows or columns!
by Immortaly007 on Jul 3, 2013 at 9:15 AM
Two words. Frickin' awesome !!
by Moonglum on Jun 1, 2013 at 5: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, 2013 at 3:52 PM
Great library with a lot of features and good performance.
by Tridus on May 22, 2013 at 6: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, 2013 at 11:31 AM
Excelent tool for export to excel. Very fast.
by ngoxuanthuan on May 10, 2013 at 4:16 PM
Excellent tool for editing/creating OpenOffice Excel documents.
by medelbrock on May 2, 2013 at 3:27 PM
Light-weight, easy to work with and seemingly comprehensive Excel export. Way to go!
by liorshapira on May 1, 2013 at 11: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, 2013 at 9: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, 2013 at 10: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, 2013 at 4: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, 2013 at 2:11 AM
Conditional formatting, print areas, XLSX support, only 600k... best of the bunch. Cheers!
by Dunc_ on Feb 28, 2013 at 3: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, 2013 at 7: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, 2013 at 9: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, 2013 at 8: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, 2013 at 10:12 PM
Great library! Thank you!
by DeadOrc on Jan 7, 2013 at 1:35 PM
Fantastic Excel library, packed with features but still small enough to include in your project...
by netizenk on Dec 17, 2012 at 8: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 4: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 5:26 PM
Very useful using it with ASP.NET
by l2mt on Nov 3, 2012 at 8:12 PM
Very easy to use. I was up and running in very little time. Thank you!
by DougJacobson on Oct 11, 2012 at 7: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 12:29 PM
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 8:25 AM
Saving an Excel Package is extremely slow. I would not recommend this if you are it to create a lot of Excel files. Also autosizing columns is another greedy function, I realize there may be no way around since it is O(n^2).
by bsherman on Jun 10, 2014 at 6:13 PM
not compatible with wps. a famous spreadsheet software in china.
by huangxianggui on Oct 21, 2012 at 7:03 AM
Given the number of bugs reported on this site I'm not the only one giving one star. Followed the VBA macro example and cannot get it to work in real world. Cant even figure out how to move an existing worksheet or even if it has these simple operations. Very disappointed, waste of time.
by mjbiddle on Apr 24, 2014 at 8:19 PM