Create advanced Excel 2007/2010 spreadsheets on the server

EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
 

EPPlus supports:

  • Cell Ranges
  • Cell styling (Border, Color, Fill, Font, Number, Alignments)
  • Charts
  • Pictures
  • Shapes
  • Comments
  • Tables
  • Protection
  • Encryption
  • Pivot tables
  • Data validation
  • Conditional formatting
  • VBA
  • Many more...

Overview

This project started with the source from ExcelPackage. It was a great project to start from.

It had the basic functionality needed to read and write a spreadsheet.

Advantages over other:

  • Totally rewritten using dictionaries
  • Can now load 50 000 cells in seconds
  • Complete integration with .NET

Examples

To see how this works let’s do a short walkthrough of sample 6 that creates a report on a directory in the file system. 
The spreadsheet is created without any template. 
First sheet is a list of subdirectories and files, with an icon, name, size, and dates. The second sheet contains some statistics...

EPPlus also supports enumeration of cells....

 Heres an example how you can use EPPlus in a webapplication...

 Here's a few screenshots from the sample project...

 

Beta of version 4.0 is here. Feel free to help us testing it. EPPlus 4.0 Beta

License

The project is licensed under the GNU Library General Public License (LGPL).

Last edited Apr 17 at 2:12 PM by JanKallman, version 54