Skip to content

Create advanced Excel spreadsheets using .NET

Notifications You must be signed in to change notification settings

MohanVijayakumar/EPPlus

 
 

Repository files navigation

EPPlus

Announcement: This repository will move to https://github.com/EPPlusSoftware/EPPlus.
EPPlus will from version 5 switch license from LGPL to Polyform Noncommercial 1.0.0 license.
With the new license EPPlus is still free to use in some cases, but will require a commercial license to be used in a commercial business. This repostitory will shortly be set to readonly.

More information on the license change on our website


Create advanced Excel spreadsheets using .NET, without the need of interop.

EPPlus is a .NET library that reads and writes Excel files using the Office Open XML format (xlsx). EPPlus has no dependencies other than .NET.  

EPPlus supports:

  • 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...

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: EPPlus uses dictionaries to access cell data, making performance a lot better. Complete integration with .NET

Support

All support is currently referred to Stack overflow. A tutorial is available in the wiki and the sample project can be downloaded with each version. The old site at Codeplex also contains material that can be helpful. Bugs and new feature requests can be added to the issues tracker.

License

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

About

Create advanced Excel spreadsheets using .NET

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C# 100.0%