EPPlus 5.4.0

A spreadsheet library for .NET framework and .NET core

Install-Package EPPlus -Version 5.4.0
dotnet add package EPPlus --version 5.4.0
<PackageReference Include="EPPlus" Version="5.4.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EPPlus --version 5.4.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

EPPlus 5.4.0
     IMPORTAT NOTICE!
     From version 5 EPPlus changes the licence model using a dual license, Polyform Non Commercial / Commercial license.
     EPPlus will still have the source available, but for non Polyform NC compliant projects, EPPlus will provide a commercial license.
     Commercial licenses can be purchased from https://epplussoftware.com/
     This applies to EPPlus version 5 and later. Previous versions are still licensed LGPL.

     ## Version 5.4.0
     ### Features
     * Pivot tables filters
     *   Item filters - Filters on individual items in row/column or page fields.
     *   Caption filters (label filters) - Filters for text on row and column fields.
     *   Date, numeric and string filters - Filters using various operators such as Equals, NotBetween, GreaterThan, etc.
     *   Top 10 filters - Filters using top or bottom criterias for percent, count or value.
     *   Dynamic filters - Filters using various date- and average criterias.
     * Add calculated fields to pivot tables.
     * Support for pivot table shared caches via the new overload for PivotTables.Add.
     * Support for pivot table slicers
     * Support for table slicers

     * Bug fixes

     ## Version 5.3.2
     * Bug fixes

     ## Version 5.3.1
     * Added support for copying threaded comments
     * Add FormulaParserManager.Parse method.
     * Bug fixes

     New features in version 5.3.0:
     * Support for Threaded Comments with mentions. See https://github.com/EPPlusSoftware/EPPlus/wiki/Threaded-comments
     * New functions MAXIFS and MINIFS
     * Bug fixes

     New features in version 5.2.1:
     * New method ExcelRange.LoadFromDictionary. Support for Dynamics in LoadFromCollection (ExpandoObject).
     * Zip64 support in packaging to enable larger packages.
     * Bug fixes.

     New features in version 5.2:

     * Support for extended chart types and stock charts:
     * Four types of stock charts: High-Low-Close, Open-High-Low-Close, Volume-High-Low-Close and Volume-Open-High-Low-Close
     * Sunburst Chart
     * Treemap Chart
     * Histogram Chart
     * Pareto Chart
     * Funnel Chart
     * Waterfall Chart
     * Box & Whisker Chart
     * Region Map Chart.
     * Support for 49 new functions in the formula calc engine, mainly finance and engineering.
     * Bug fixes

     New features in version 5.0 and 5.1:
     * Extensively improved chart and drawing functionality/styling
     * Theme support
     * Filter support
     * Async / Await support for I/O operations
     * Ignore Error on cells
     * Improvements of the formula calc engine and over 100 new supported functions
     * Refactored/improved codebase
     * Insert/Delete in ranges and tables.

     Breaking Changes
     * The default behavior for the Worksheet collection base in .NET Framework has changed from 1 to 0. This is the same default behavior as in .NET core today.
     * Pictures have changed the behavior as the oneCellAnchor tag is used instead of the twoCellAnchor tag with the editAs="oneCell".
     * Pivot tables will always refresh on load.
     * ...and more, see https://epplussoftware.com/docs/5.3/articles/breakingchanges.html

     Worksheets collection behavior in .NET Framework
     The default behavior for the Worksheet collection base in .NET Framework has changed from 1 to 0. This is the same behavior as in .NET Core.
     For backward compatibility the property IsWorksheets1Based can be set to true, to have the same behavior as in previous version of EPPlus. This property can also be set in the app.config.
     For more details see https://github.com/EPPlusSoftware/EPPlus/wiki/Breaking-Changes-in-EPPlus-5.0
     A list of fixed issues can be found here https://epplussoftware.com/docs/5.3/articles/fixedissues.html

     Version history
     5.4.0 20201008 Table- and Pivot Table- Slicers. Pivot Table Filters. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
     5.3.2 20200914 Bug fixes.
     5.3.1 20200902 Minor features and bug fixes.
     5.3.0 20200819 Support for threaded comment with mentions. Minor feature and bug fixes.
     5.2.1 20200722 Minor features and bug fixes.
     5.2.0 20200623 Support for 12 new chart types. Minor features and bug fixes.
     5.1.2 20200513 Minor features and bug fixes.
     5.1.1 20200427 Minor bug fixes.
     5.1.0 20200401 Insert, Delete in Ranges and Tables. Minor bug fixes.
     5.0.4 20200310 Minor bug fixes.
     5.0.3 20200308 Initial release EPPlus 5

NuGet packages (387)

Showing the top 5 NuGet packages that depend on EPPlus:

Package Downloads
iRely.Common
iRely.Common
UmbracoForms.Core
Umbraco Forms, the tool that makes creating contact forms, entry forms and questionnaires just as easy as using Word.
Xrm.Sdk.PluginRegistration
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.
Ryr.XrmToolBox.ExportToExcel
Easily export records from the selected view/fetchxml to Excel.
EPPlus.Core.Extensions
An extensions library for EPPlus package to generate and manipulate Excel files easily.

GitHub repositories (23)

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

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

Version History

Version Downloads Last updated
5.4.0 17,412 10/8/2020
5.3.2 56,394 9/14/2020
5.3.1 28,311 9/2/2020
5.3.0 37,472 8/20/2020
5.2.1 96,520 7/22/2020
5.2.0 93,900 6/24/2020
5.1.2 172,108 5/13/2020
5.1.1 94,649 4/27/2020
5.1.0 112,812 4/7/2020
5.0.4 242,924 3/10/2020
5.0.3 12,617 3/8/2020
5.0.2-rc 1,193 3/1/2020
5.0.1-beta 4,307 2/11/2020
5.0.0-beta 2,019 1/30/2020
4.5.3.3 1,406,080 1/30/2020
4.5.3.2 3,661,384 6/16/2019
4.5.3.1 2,321,737 2/3/2019
4.5.3 467,757 1/6/2019
4.5.2.1 3,019,494 5/30/2018
4.5.2 104,065 5/24/2018
4.5.1 630,927 3/25/2018
4.5.0.3-rc 10,245 3/5/2018
4.5.0.2-rc 24,283 2/4/2018
4.5.0.1-beta 50,231 11/28/2017
4.5.0-beta 18,267 11/12/2017
4.1.1 1,758,237 10/8/2017
4.1.0 3,477,272 7/14/2016
4.0.5 1,355,300 1/8/2016
4.0.4 966,481 4/24/2015
4.0.3 232,203 2/12/2015
4.0.2 77,758 1/14/2015
4.0.1.1 75,264 11/30/2014
4.0.0-rc1 4,377 11/11/2014
4.0.0-beta2 20,092 4/18/2014
3.1.3.3 769,891 4/14/2013
3.1.3.2 14,408 4/14/2013
3.1.3 65,749 4/14/2013
3.1.2 83,682 11/6/2012
3.1.1 16,748 9/26/2012
3.1.0-beta 2,369 7/22/2012
3.0.0.2 80,130 2/1/2012
3.0.0.1 2,753 2/1/2012
2.9.0.1 16,563 6/2/2011
2.8.0.2 16,072 3/3/2011