EPPlus 5.6.0

Prefix Reserved

.NET 5.0 .NET Standard 2.0 .NET Framework 3.5

There is a newer version of this package available.
See the version list below for details.

dotnet add package EPPlus --version 5.6.0

NuGet\Install-Package EPPlus -Version 5.6.0

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="EPPlus" Version="5.6.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add EPPlus --version 5.6.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: EPPlus, 5.6.0"

#r directive can be used in F# Interactive and Polyglot Notebooks. 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.6.0

// Install EPPlus as a Cake Tool
#tool nuget:?package=EPPlus&version=5.6.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

A spreadsheet library for .NET framework and .NET core

Product	Compatible and additional computed target framework versions.
.NET	net5.0 is compatible. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed.
.NET Core	netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed.
.NET Standard	netstandard2.0 is compatible. netstandard2.1 is compatible.
.NET Framework	net35 is compatible. net40 is compatible. net403 was computed. net45 is compatible. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed.
MonoAndroid	monoandroid was computed.
MonoMac	monomac was computed.
MonoTouch	monotouch was computed.
Tizen	tizen40 was computed. tizen60 was computed.
Xamarin.iOS	xamarinios was computed.
Xamarin.Mac	xamarinmac was computed.
Xamarin.TVOS	xamarintvos was computed.
Xamarin.WatchOS	xamarinwatchos was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

.NETFramework 3.5
- No dependencies.
.NETFramework 4.0
- Microsoft.IO.RecyclableMemoryStream (>= 1.4.1)
.NETFramework 4.5
- Microsoft.IO.RecyclableMemoryStream (>= 1.4.1)
- System.ComponentModel.Annotations (>= 4.7.0)
.NETStandard 2.0
- Microsoft.Extensions.Configuration.Json (>= 3.1.10)
- Microsoft.IO.RecyclableMemoryStream (>= 1.4.1)
- System.ComponentModel.Annotations (>= 4.7.0)
- System.ComponentModel.TypeConverter (>= 4.3.0)
- System.Data.Common (>= 4.3.0)
- System.Drawing.Common (>= 4.7.1)
- System.Reflection (>= 4.3.0)
- System.Security.Claims (>= 4.3.0)
- System.Security.Cryptography.Pkcs (>= 4.7.0)
- System.Security.Cryptography.X509Certificates (>= 4.3.2)
- System.Text.Encoding.CodePages (>= 4.7.1)
- System.Xml.XmlDocument (>= 4.3.0)
- System.Xml.XPath.XmlDocument (>= 4.3.0)
.NETStandard 2.1
- Microsoft.Extensions.Configuration.Json (>= 3.1.10)
- Microsoft.IO.RecyclableMemoryStream (>= 1.4.1)
- System.ComponentModel.Annotations (>= 4.7.0)
- System.ComponentModel.TypeConverter (>= 4.3.0)
- System.Data.Common (>= 4.3.0)
- System.Drawing.Common (>= 4.7.1)
- System.Reflection (>= 4.3.0)
- System.Security.Claims (>= 4.3.0)
- System.Security.Cryptography.Pkcs (>= 4.7.0)
- System.Security.Cryptography.X509Certificates (>= 4.3.2)
- System.Text.Encoding.CodePages (>= 4.7.1)
- System.Xml.XmlDocument (>= 4.3.0)
- System.Xml.XPath.XmlDocument (>= 4.3.0)
net5.0
- Microsoft.Extensions.Configuration.Json (>= 5.0.0)
- Microsoft.IO.RecyclableMemoryStream (>= 1.4.1)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.ComponentModel.TypeConverter (>= 4.3.0)
- System.Data.Common (>= 4.3.0)
- System.Drawing.Common (>= 5.0.0)
- System.Reflection (>= 4.3.0)
- System.Security.Claims (>= 4.3.0)
- System.Security.Cryptography.Pkcs (>= 5.0.0)
- System.Security.Cryptography.X509Certificates (>= 4.3.2)
- System.Text.Encoding.CodePages (>= 5.0.0)
- System.Xml.XmlDocument (>= 4.3.0)
- System.Xml.XPath.XmlDocument (>= 4.3.0)

NuGet packages (807)

Showing the top 5 NuGet packages that depend on EPPlus:

Package	Downloads
iRely.Common iRely.Common	2.5M
UmbracoForms.Core Umbraco Forms is an extension for Umbraco CMS allowing editors to create and manage forms and review submissions. The packages available from this feed can be used with Umbraco CMS versions up to version 8. For Umbraco CMS version 9, please use the feed available at https://www.nuget.org/packages/Umbraco.Forms/	1.9M
Dynamicweb.Data Data access API	1.7M
Umbraco.Forms.Core.Providers Umbraco Forms Core Providers encapsulates core providers of the forms builder for use by package developers.	1.4M
EPPlus.Core.Extensions An extensions library for EPPlus package to generate and manipulate Excel files easily.	1.0M

GitHub repositories (62)

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

Repository	Stars
ldqk/Masuit.Tools 全龄段友好的C#万能工具库，码数吐司库，包含一些常用的操作类，大都是静态类，加密解密，反射操作，权重随机筛选算法，分布式短id，表达式树，linq扩展，文件压缩，多线程下载，硬件信息，字符串扩展方法，日期时间扩展操作，中国农历，大文件拷贝，图像裁剪，验证码，断点续传，集合扩展、Excel导出等常用封装。诸多功能集一身，代码量不到2MB！	5.6K
ivanpaulovich/clean-architecture-manga :cyclone: Clean Architecture with .NET6, C#10 and React+Redux. Use cases as central organizing structure, completely testable, decoupled from frameworks	4.0K
fullstackhero/blazor-starter-kit Clean Architecture Template for Blazor WebAssembly Built with MudBlazor Components.	3.5K
mini-software/MiniExcel Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)	2.8K
smartstore/SmartStoreNET Open Source ASP.NET MVC Enterprise eCommerce Shopping Cart Solution	2.6K

Version	Downloads	Last updated
7.5.1	8,835	11/21/2024
7.5.0	32,167	11/15/2024
7.4.2	142,942	10/28/2024
7.4.1	147,219	10/11/2024
7.4.0	128,228	10/2/2024
7.3.2	164,400	9/17/2024
7.3.1	157,443	9/5/2024
7.3.0	206,215	8/20/2024
7.2.2	407,149	7/24/2024
7.2.1	404,065	7/2/2024
7.2.0	254,086	6/18/2024
7.1.3	399,661	5/28/2024
7.1.2	636,492	4/23/2024
7.1.1	371,296	4/8/2024
7.1.0	173,213	3/28/2024
7.0.10	345,946	3/11/2024
7.0.9	563,388	2/15/2024
7.0.8	470,100	1/24/2024
7.0.7	94,014	1/19/2024
7.0.6	237,817	1/10/2024
7.0.5	321,517	12/22/2023
7.0.4	175,935	12/15/2023
7.0.3	278,065	12/5/2023
7.0.2	230,592	11/23/2023
7.0.1	286,933	11/9/2023
7.0.0	266,836	10/26/2023
6.2.19	147,976	3/27/2024
6.2.18	17,131	3/11/2024
6.2.17	10,656	2/15/2024
6.2.16	28,833	1/10/2024
6.2.15	44,466	12/15/2023
6.2.14	6,618	12/5/2023
6.2.13	7,051	11/23/2023
6.2.12	13,053	11/9/2023
6.2.11	47,401	10/26/2023
6.2.10	598,118	10/2/2023
6.2.9	474,232	9/8/2023
6.2.8	613,664	8/15/2023
6.2.7	519,629	7/19/2023
6.2.6	792,632	6/15/2023
6.2.5	22,196	6/14/2023
6.2.4	679,281	5/15/2023
6.2.3	322,044	5/2/2023
6.2.2	367,327	4/17/2023
6.2.1	210,085	4/6/2023
6.2.0	296,582	3/24/2023
6.1.3	830,968	2/24/2023
6.1.2	905,099	1/19/2023
6.1.1	1,310,404	11/21/2022
6.1.0	520,327	11/3/2022
6.0.8	1,193,889	9/21/2022
6.0.7	780,852	8/30/2022
6.0.6	1,329,038	7/8/2022
6.0.5	666,585	6/10/2022
6.0.4	665,061	5/12/2022
6.0.3	1,330,480	4/12/2022
5.8.14	561,069	9/21/2022
5.8.13	8,182	8/30/2022
5.8.12	86,904	7/8/2022
5.8.11	14,242	6/10/2022
5.8.10	45,016	5/12/2022
5.8.9	63,654	4/11/2022
5.8.8	484,142	3/22/2022
5.8.7	708,094	3/1/2022
5.8.6	613,522	2/3/2022
5.8.5	483,215	1/13/2022
5.8.4	712,118	12/14/2021
5.8.3	566,108	11/19/2021
5.8.2	524,506	10/29/2021
5.8.1	95,230	10/26/2021
5.8.0	176,217	10/21/2021
5.7.5	768,164	9/21/2021
5.7.4	585,359	8/26/2021
5.7.3	302,379	8/10/2021
5.7.2	553,188	7/22/2021
5.7.1	313,238	7/6/2021
5.7.0	593,902	6/17/2021
5.6.4	899,635	5/12/2021
5.6.3	824,802	4/16/2021
5.6.2	167,726	4/7/2021
5.6.1	411,679	3/22/2021
5.6.0	194,903	3/15/2021
5.5.5	537,183	2/23/2021
5.5.4	170,887	2/16/2021
5.5.3	791,424	2/3/2021
5.5.2	444,172	1/18/2021
5.5.1	161,460	1/12/2021
5.5.0	398,123	12/18/2020
5.4.2	704,981	11/19/2020
5.4.1	357,133	11/5/2020
5.4.0	634,239	10/8/2020
5.3.2	613,836	9/14/2020
5.3.1	229,293	9/2/2020
5.3.0	241,115	8/20/2020
5.2.1	576,494	7/22/2020
5.2.0	611,506	6/24/2020
5.1.2	730,436	5/13/2020
5.1.1	415,872	4/27/2020
5.1.0	511,475	4/7/2020
5.0.4	667,044	3/10/2020
5.0.3	352,675	3/8/2020
4.5.3.3	23,262,138	1/30/2020
4.5.3.2	17,370,742	6/16/2019
4.5.3.1	6,712,245	2/3/2019
4.5.3	1,717,393	1/6/2019
4.5.2.1	8,522,852	5/30/2018
4.5.2	444,049	5/24/2018
4.5.1	2,200,919	3/25/2018
4.1.1	3,552,349	10/8/2017
4.1.0	8,433,357	7/14/2016
4.0.5	2,770,184	1/8/2016
4.0.4	1,847,234	4/24/2015
4.0.3	685,261	2/12/2015
4.0.2	196,754	1/14/2015
4.0.1.1	256,389	11/30/2014

EPPlus 5.6.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.6.0
     * Custom table styles.
     *   Create and modify custom table styles that can be applied to tables and pivot tables.
     *   Create and modify custom slicer styles
     * Pivot table styling using pivot areas to style individual areas within a pivot table.
     * Enhanced table styling
     * Added three new style properties to the ExcelTable and ExcelTableColumn
     *   HeaderRowStyle
     *   DataStyle
     *   TotalsRowStyle
     * Bug fixes. https://epplussoftware.com/Developers/MinorFeaturesAndIssues

     ## Version 5.5.5
     * Bug fixes.

     ## Version 5.5.4
     * Bug fixes.

     ## Version 5.5.3
     * Bug fixes.

     ## Version 5.5.2
     * Bug fixes.

     ## Version 5.5.1
     * 10 new functions
     * Bug fixes.

     ## 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.
     * Adding and inserting table row will now copy styles from the row above.
     * ...and more, see https://epplussoftware.com/docs/5.6/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.6/articles/fixedissues.html

     Version history
     5.6.0 20210315 Custom table styles. Pivot table styling. Table styling enhancements.
     5.5.5 20210223 Minor bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
     5.5.4 20210216 Minor bug fixes.
     5.5.3 20210206 Minor bug fixes.
     5.5.2 20210118 Minor bug fixes.
     5.5.1 20210111 Minor features and bug fixes.
     5.5.0 20201218 Form Controls.
     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

EPPlus 5.6.0

.NETFramework 3.5

.NETFramework 4.0

.NETFramework 4.5

.NETStandard 2.0

.NETStandard 2.1

net5.0

NuGet packages (807)

GitHub repositories (62)