EPPlus 5.2.1

A spreadsheet library for .NET framework and .NET core

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

Release Notes

EPPlus 5.2.1
     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.
     This applies to EPPlus version 5 and later. Previous versions are still licensed LGPL.

     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".
     * ...and more, see https://epplussoftware.com/docs/5.2/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.2/articles/fixedissues.html

     Version history
     5.0.3 20200308 Initial release EPPlus 5
     5.0.4 20200310 Minor bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
     5.1.0 20200401 Insert, Delete in Ranges and Tables. Minor bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
     5.1.1 20200427 Minor bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
     5.1.2 20200513 Minor features and bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
     5.2.0 20200623 Support for 12 new chart types. Minor features and bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
     5.2.1 20200722 Minor features and bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues

NuGet packages (353)

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 XrmToolBox plugin and intended to work with the same set of the Dynamics CRM versions as supported by main application.
Ryr.XrmToolBox.ExportToExcel
Easily export records from the selected view/fetchxml to Excel.
Griddly.Core
Pagable sortable MVC enabled grid (core files only)

GitHub repositories (22)

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 的业务模块化以及前后端分离的快速开发框架
dotnetcore/Magicodes.IE
导入导出通用库,支持Dto导入导出以及动态导出,支持Excel、Csv、Word、Pdf和Html。

Version History

Version Downloads Last updated
5.2.1 20,081 7/22/2020
5.2.0 53,100 6/24/2020
5.1.2 119,644 5/13/2020
5.1.1 70,501 4/27/2020
5.1.0 84,719 4/7/2020
5.0.4 203,714 3/10/2020
5.0.3 10,463 3/8/2020
5.0.2-rc 1,108 3/1/2020
5.0.1-beta 3,966 2/11/2020
5.0.0-beta 1,914 1/30/2020
4.5.3.3 928,854 1/30/2020
4.5.3.2 3,105,049 6/16/2019
4.5.3.1 2,092,759 2/3/2019
4.5.3 423,186 1/6/2019
4.5.2.1 2,732,874 5/30/2018
4.5.2 94,127 5/24/2018
4.5.1 575,298 3/25/2018
4.5.0.3-rc 10,007 3/5/2018
4.5.0.2-rc 23,463 2/4/2018
4.5.0.1-beta 48,892 11/28/2017
4.5.0-beta 17,327 11/12/2017
4.1.1 1,633,693 10/8/2017
4.1.0 3,275,590 7/14/2016
4.0.5 1,276,982 1/8/2016
4.0.4 926,033 4/24/2015
4.0.3 208,696 2/12/2015
4.0.2 72,585 1/14/2015
4.0.1.1 71,583 11/30/2014
4.0.0-rc1 4,227 11/11/2014
4.0.0-beta2 19,826 4/18/2014
3.1.3.3 728,770 4/14/2013
3.1.3.2 12,622 4/14/2013
3.1.3 61,900 4/14/2013
3.1.2 79,950 11/6/2012
3.1.1 16,503 9/26/2012
3.1.0-beta 2,283 7/22/2012
3.0.0.2 72,425 2/1/2012
3.0.0.1 2,645 2/1/2012
2.9.0.1 15,864 6/2/2011
2.8.0.2 15,633 3/3/2011