EPPlus 5.5.0

A spreadsheet library for .NET framework and .NET core

There is a newer version of this package available.
See the version list below for details.
Install-Package EPPlus -Version 5.5.0
dotnet add package EPPlus --version 5.5.0
<PackageReference Include="EPPlus" Version="5.5.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EPPlus --version 5.5.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: EPPlus, 5.5.0"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install EPPlus as a Cake Addin
#addin nuget:?package=EPPlus&version=5.5.0

// Install EPPlus as a Cake Tool
#tool nuget:?package=EPPlus&version=5.5.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

EPPlus 5.5.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.5.0
     * Form Controls
     *   Buttons
     *   Drop-Downs
     *   List Boxes
     *   Check Boxes
     *   Radio Buttons
     *   Spin Buttons
     *   Scroll Bars
     *   Labels
     *   Group Boxes
     * Group/Ungroup drawing object via the ExcelDrawing.Group and ExcelDrawing.Ungroup methods
     * New attribute support for LoadFromCollection. See https://github.com/EPPlusSoftware/EPPlus/wiki/LoadFromCollection-using-Attributes
     * 20 new functions
     * Bug fixes

     ## Version 5.4.2
     * .NET 5.0
     * Bug fixes

     ## Version 5.4.1
     # Features
     * WriteProtection added to Workbook.Protection. Allows to set a workbook to read-only with a password.
     * ToDataTable method added to ExcelRange
     * Bug fixes

     ## 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.5/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.5/articles/fixedissues.html

     Version history
     5.5.0 20201218 Form Controls. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
     5.4.2 20201119 Minor features and bug fixes.
     5.4.1 20201105 Minor features and bug fixes.
     5.4.0 20201008 Table- and Pivot Table- Slicers. Pivot Table Filters.
     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 (432)

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.
Dynamicweb.Data
Dynamicweb 9 package that provides the data access API
Ryr.XrmToolBox.ExportToExcel
Easily export records from the selected view/fetchxml to Excel.

GitHub repositories (26)

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
egametang/ET
Unity3D Client And C# Server Framework
smartstore/SmartStoreNET
Open Source ASP.NET MVC Enterprise eCommerce Shopping Cart Solution
iamoldli/NetModular
NetModular 是基于.Net Core 和 Vue.js 的业务模块化以及前后端分离的快速开发框架
ariacom/Seal-Report
Open Database Reporting Tool (.Net)

Version History

Version Downloads Last updated
5.6.3 1,068 4/16/2021
5.6.2 11,508 4/7/2021
5.6.1 28,635 3/22/2021
5.6.0 17,871 3/15/2021
5.5.5 73,025 2/23/2021
5.5.4 27,644 2/16/2021
5.5.3 41,079 2/3/2021
5.5.2 63,252 1/18/2021
5.5.1 20,588 1/12/2021
5.5.0 91,481 12/18/2020
5.4.2 142,311 11/19/2020
5.4.1 72,740 11/5/2020
5.4.0 169,825 10/8/2020
5.3.2 157,180 9/14/2020
5.3.1 63,236 9/2/2020
5.3.0 79,141 8/20/2020
5.2.1 201,022 7/22/2020
5.2.0 163,166 6/24/2020
5.1.2 269,381 5/13/2020
5.1.1 134,903 4/27/2020
5.1.0 170,656 4/7/2020
5.0.4 320,021 3/10/2020
5.0.3 20,494 3/8/2020
5.0.2-rc 1,428 3/1/2020
5.0.1-beta 4,708 2/11/2020
5.0.0-beta 2,485 1/30/2020
4.5.3.3 2,830,937 1/30/2020
4.5.3.2 5,006,282 6/16/2019
4.5.3.1 2,819,582 2/3/2019
4.5.3 586,236 1/6/2019
4.5.2.1 3,739,011 5/30/2018
4.5.2 137,298 5/24/2018
4.5.1 780,987 3/25/2018
4.1.1 2,040,152 10/8/2017
4.1.0 3,999,624 7/14/2016
4.0.5 1,547,274 1/8/2016
4.0.4 1,056,347 4/24/2015
4.0.3 287,377 2/12/2015
4.0.2 91,655 1/14/2015
4.0.1.1 87,141 11/30/2014
Show less