EPPlus 3.0.0.2

Rating:        Based on 18 ratings
Reviewed:  17 reviews
Downloads: 30315
Change Set: db8aef53995f
Released: Jan 31, 2012
Updated: Feb 1, 2012 by JanKallman
Dev status: Stable Help Icon

Recommended Download

Application EPPlus 3.0 Binaries
application, 213K, uploaded Jan 31, 2012 - 16801 downloads

Other Available Downloads

Example EPPlus 3.0 Sample Including Binary
example, 270K, uploaded Jan 31, 2012 - 7658 downloads
Application EPPlus 3.0 Documentation (chm-file)
application, 2449K, uploaded Jan 31, 2012 - 5856 downloads

Release Notes

EPPlus-Create advanced Excel 2007 spreadsheets on the server

This version actually don't contain any new major functionallity. The major change is the licence that goes from GPL --> LGPL.
Theres also whole bunch of bugfixes since 2.9
A lot of stuff has been rewritten,so I took the opportunity to change a few things in the interface and behavior.

New features

LGPL

This version changes the version from GPL to LGPL (I have rewritten a lot of old stuff from the Excelpackage project to make this possible).

Backgroundimages

Backgroundimage property added to ExcelWorksheet class.

Header and footer images

Pictures collection added to ExcelHeaderFooter class

Gradiant cell backgrounds fills

Gradient property added to the ExcelFill class

Interface changes

Renamed properties ExcelWorksheet...

defaultColWidth --> DefaultColWidth
defaultRowHeight --> DefaultRowHeight

Renamed Properties ExcelHeaderFooter...

oddHeader -->OddHeader
oddFooter --> OddFooter
evenHeader --> EvenHeader
evenFooter --> EvenFooter
firstHeader --> FirstHeader
firstFooter --> FirstFooter

Behavior change

Cells collection

Using the cells collection without the indexer didn't work that well in the previous versions.
From version 3.0, using the Cells collection without the indexer will reference all cells.
Setting values, formulas etc in this matter will throw an Exception

Resizing of drawings when column width and row height are changed

Drawings (charts, shapes and pictures) will now size when row height and column width are changed, depending on the EditAs property. This behavior can be turned of by setting the ExcelPackage.DoAdjustDrawings to false

Cells.Value property return an array if more than one cell is specified in the indexer.

New Properties and Classes

  • ToolTip property added to ExcelHyperlink
  • LockText property added to ExcelShape
  • ExcelLineChartSeries class added (to enable change of markers).
  • MajorTickMark and MinorTickMark added to ExcelChartAxis (Thanks Mario)
  • CalculatedColumnFormula added to ExcelTableColumn (Thanks Maverick)
  • SubTotalFunctions property added to ExcelPivotTableField
  • UnderLineStyle added to ExcelFont
  • ShowFilter added to ExcelTable

Reviews for this release

     
This is a really good option to replace EXCEL COM and other configuration settings for the same on the server.
by PRANAVDEO on Sep 5, 2012 at 9:52 AM
     
Very easy to use, got me up and running with my project in just minutes!
by MrBruins on Aug 30, 2012 at 7:32 AM
     
This kills all competing products! It is by far the easiest to use and most efficient component in this field.
by henrikweimenhog on Aug 23, 2012 at 6:48 PM
     
Really easy to use. Thank you very much!
by nZeus on Aug 7, 2012 at 7:12 AM
     
This project has made my life 10 times easier. Thanks for the hard work!
by MadHatter22 on Jul 24, 2012 at 9:58 PM
     
Great project! Easy to use, saved so much time and effort.
by Rellimka on Jul 10, 2012 at 5:21 PM
     
So cool, and easy to use!
by Nielsen on Jun 28, 2012 at 2:00 PM
     
Keep up the good work!, reduce memory consumption to export large amounts of data would be great.
by Audor27 on Jun 26, 2012 at 3:30 PM
     
This is an excellent release.
by aspnetrazor on Jun 13, 2012 at 2:22 PM
     
You've just made my life so much easier! Byebye VBA. 5 stars once conditional formatting is there as well.
by timdams on Jun 13, 2012 at 1:41 PM
     
This project makes me a happy coder!
by dsmit on Jun 3, 2012 at 10:23 PM
     
Brilliant alternative to aspose cells, great job, Thanks!
by Harps on May 9, 2012 at 2:38 PM
     
Could not use due to restrictive license. Please open it up.
by paulwhit on May 8, 2012 at 10:57 PM
     
Excellent project.
by edddy on May 8, 2012 at 10:48 PM
     
I really like column auto-fit feature.
by ubikuity on May 5, 2012 at 7:10 PM
     
So far so good!
by vinyl on Apr 20, 2012 at 3:17 PM
     
It's Great
by gmocontreras on Apr 16, 2012 at 3:09 PM