Create advanced Excel spreadsheets using DotNet, without the need of interop.
EPPlus is a .net library that reads and writes Excel files using the Open Office Xml format (xlsx). EPPlus has no dependens other than DotNet.
- Cell Ranges
- Cell styling (Border, Color, Fill, Font, Number, Alignments)
- Data validation
- Conditional formatting
- Charts
- Pictures
- Shapes
- Comments
- Tables
- Pivot tables
- Protection
- Encryption
- VBA
- Formula calculation
- Many more...
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: EPPlus uses dictionaries to access cell data, making performance a lot better. Complete integration with .NET
The project is licensed under the GNU Library General Public License (LGPL).