A library to manage Excel spreadsheets, using OOXML.

There is a newer version of this package available.
See the version list below for details.
The owner has unlisted this package. This could mean that the package is deprecated or shouldn't be used anymore.
Install-Package EPPlus -Version
dotnet add package EPPlus --version
<PackageReference Include="EPPlus" Version="" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EPPlus --version
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

EPPlus 3.1.3

Visit epplus.codeplex.com for the latest information

This version contain version contains two new major features - VBA and conditional formatting

New features

Create,read and write a VBA project from scratch or in a template.
Add and modify modules and classes.
Read and write code to documents(workbook and worksheets), modules and classes.
VBA protection
Code signing
And more...

Conditional Formatting
Apply conditional formatting on any range of cells.
Choose between more than 40 different types ("beginsWith", "between", "containsText", "endsWith", "equal", "greaterThan", "greaterThanOrEqual", "iconSet3", "iconSet4", "iconSet5", "last7Days", "lastMonth" and many more)

Minor new features
Picture Hyperlinks
Chart Axis Titles
Remove method added to Drawings collection

An a lot of bug fixes

3.1.2 changes
* Fixes problem with messed up Normal style if the Normal style is not the first saved Style in the NamedStyles collection.
* Fixed problem with CellIs in templates (14750, 14749).Turned off dtd on XmlDocument.Load / LoadXml to avoid Xml-bombs. Fixed pivottable constructor that set default values in templates(14723).
* Fixes problem with indexed colors in conditional formatting.
* Fixes full row / column ranges with defined names (throwing exception when accessing Start and End properties).

3.1.3 changes
* Fixed VBA project corruption when adding a new worksheet.
* Fixed Drawing resizing with hidden rows.
* Fixed problem with named styles and blank text property on range when it shold be "0"
* Fixes issue 14768-Missing Normal style causes corruption of xfs styles.
* Fixed issue 14799-Table-StyleName bug.
* Fixed issue 14799-Change of contenttype from xlsx to xlsm and pivottable caused corruption
* Fixed issue 14795-Scatterchart smooth lines.
* Fixed issue 14809-Namedstyles was invalid when loading from a template
* Fixed issue 14805-LoadFromText did not work with a null argument for parameter Text)
* Fixed issue 14819-Setting data validations default operator to Any.
* Fixed issue 14823-Invalid hyperlinks when uri was encoded.
* Fixed issue 14818-attribute createdVersion of the Pivottable was set to 1 and causing the pivottable ignore the enableDrill and showDrill attributes
* Fixed issue 14803-Duplicate column names when creating a table caused a corrupt workbook.
* Fixed issue 14820-Invalid sort order on header footer elements when creating from a template. Added reference to System.Web for Uri decoding


This package has no dependencies.

NuGet packages (397)

Showing the top 5 NuGet packages that depend on EPPlus:

Package Downloads
Umbraco Forms, the tool that makes creating contact forms, entry forms and questionnaires just as easy as using Word.
The Classic Microsoft Dynamics CRM tool, now in the XrmToolBox suite. This is special flavor of classical Plugin Registration Tool provided by Microsoft as CRM SDK code sample. It was adopted to the format of an XrmToolBox tool and intended to work with the same set of the Common Data Service / Dynamics 365 / CRM versions as supported by main application.
Easily export records from the selected view/fetchxml to Excel.
Dynamicweb 9 package that provides the data access API

GitHub repositories (23)

Showing the top 5 popular GitHub repositories that depend on EPPlus:

Repository Stars
The most popular open-source eCommerce shopping cart solution based on ASP.NET Core
Open Source ASP.NET MVC Enterprise eCommerce Shopping Cart Solution
NetModular 是基于.Net Core 和 Vue.js 的业务模块化以及前后端分离的快速开发框架
Open Database Reporting Tool (.Net)

Version History

Version Downloads Last updated
5.4.2 15,990 11/19/2020
5.4.1 27,588 11/5/2020
5.4.0 79,050 10/8/2020
5.3.2 90,214 9/14/2020
5.3.1 38,740 9/2/2020
5.3.0 47,183 8/20/2020
5.2.1 124,556 7/22/2020
5.2.0 111,562 6/24/2020
5.1.2 196,950 5/13/2020
5.1.1 107,639 4/27/2020
5.1.0 126,875 4/7/2020
5.0.4 264,513 3/10/2020
5.0.3 14,027 3/8/2020
5.0.2-rc 1,247 3/1/2020
5.0.1-beta 4,436 2/11/2020
5.0.0-beta 2,093 1/30/2020 1,717,301 1/30/2020 3,995,074 6/16/2019 2,453,907 2/3/2019
4.5.3 496,990 1/6/2019 3,197,446 5/30/2018
4.5.2 111,111 5/24/2018
4.5.1 666,327 3/25/2018
4.1.1 1,831,937 10/8/2017
4.1.0 3,615,803 7/14/2016
4.0.5 1,405,412 1/8/2016
4.0.4 992,672 4/24/2015
4.0.3 245,350 2/12/2015
4.0.2 83,322 1/14/2015 77,684 11/30/2014
Show less