New project : EPPlus

Topics: Developer Forum, User Forum
Mar 30, 2010 at 7:50 PM

Ok, so it's not that new anymore. I started this project in December last year since this project is dead. I thought this project was great, but missed a few thing.
So, whats new in EPPlus.
Ranges and styling has been added. That means the interface has changed a little bit.
Instead of the Cell- method, cells are access using the Cells property. That means you can do something like this with your worksheet variable...

ws.Cells["A1:E1"].Style.Font.Bold=true
//or
ws.Cells["E2:E300"].Formula="C1+D1"

This project also has support for Picture, Shapes and most Graphs and a lot of other thing.
I have been working hard with the performance as well, rewriting the cell handling using a dictionary implementation.
Have a look at sample 7, that loads 65535 rows, 5 columns i about 15 sec.
Actually, in the new release 2.6, it is a total rewrite.

Have a look at epplus.codeplex.com 

There is still a lot of things to improve, so send me a message if you think you can help out.

Jan Källman

Apr 2, 2010 at 8:21 PM

Just letting you know that the embedded link in your post does not go to epplus.codeplex.com if you click on it.