Create advanced Excel 2007/2010 spreadsheets on the serverEPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
- Cell Ranges
- Cell styling (Border, Color, Fill, Font, Number, Alignments)
- Pivot tables
- Data validation
- Many more...
OverviewThis 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
ExamplesTo 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...