EPPlus 5.5.2
A spreadsheet library for .NET framework and .NET core
No packages depend on EPPlus.
EPPlus 5.5.2
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.2
* Bug fixes. https://epplussoftware.com/Developers/MinorFeaturesAndIssues
## 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.
* ...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.2 20200118 Minor bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
5.5.1 20200111 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
.NET Framework 3.5
- No dependencies.
.NET Standard 2.0
- System.Security.Cryptography.Pkcs (>= 4.7.0)
- System.Security.Cryptography.X509Certificates (>= 4.3.2)
- System.Text.Encoding.CodePages (>= 4.7.1)
- System.Xml.XPath.XmlDocument (>= 4.3.0)
- System.Xml.XmlDocument (>= 4.3.0)
- System.Reflection (>= 4.3.0)
- System.Drawing.Common (>= 4.7.1)
- System.Security.Claims (>= 4.3.0)
- System.ComponentModel.TypeConverter (>= 4.3.0)
- System.Data.Common (>= 4.3.0)
- Microsoft.Extensions.Configuration.Json (>= 3.1.10)
- Microsoft.IO.RecyclableMemoryStream (>= 1.3.6)
- System.ComponentModel.Annotations (>= 4.7.0)
.NET Standard 2.1
- Microsoft.Extensions.Configuration.Json (>= 3.1.10)
- Microsoft.IO.RecyclableMemoryStream (>= 1.3.6)
- System.ComponentModel.Annotations (>= 4.7.0)
- System.ComponentModel.TypeConverter (>= 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.XPath.XmlDocument (>= 4.3.0)
- System.Xml.XmlDocument (>= 4.3.0)
- System.Data.Common (>= 4.3.0)
.NET Framework 4.0
- Microsoft.IO.RecyclableMemoryStream (>= 1.3.6)
.NET Framework 4.5
- Microsoft.IO.RecyclableMemoryStream (>= 1.3.6)
- System.ComponentModel.Annotations (>= 4.7.0)
.NET 5.0
- Microsoft.Extensions.Configuration.Json (>= 5.0.0)
- Microsoft.IO.RecyclableMemoryStream (>= 1.3.6)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.ComponentModel.TypeConverter (>= 4.3.0)
- System.Drawing.Common (>= 5.0.0)
- System.Reflection (>= 4.3.0)
- System.Data.Common (>= 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.XPath.XmlDocument (>= 4.3.0)
- System.Xml.XmlDocument (>= 4.3.0)
- System.Security.Claims (>= 4.3.0)
| Version | Downloads | Last updated |
|---|---|---|
| 7.1.2 | 2 | 04/27/2024 |
| 7.1.1 | 2 | 04/12/2024 |
| 7.1.0 | 1 | 04/14/2024 |
| 7.0.10 | 3 | 03/13/2024 |
| 7.0.9 | 3 | 02/18/2024 |
| 7.0.8 | 2 | 01/24/2024 |
| 7.0.7 | 2 | 01/22/2024 |
| 7.0.6 | 3 | 01/12/2024 |
| 7.0.5 | 3 | 01/05/2024 |
| 7.0.4 | 2 | 12/15/2023 |
| 7.0.3 | 4 | 12/06/2023 |
| 7.0.2 | 3 | 11/29/2023 |
| 7.0.1 | 5 | 11/09/2023 |
| 7.0.0 | 3 | 10/26/2023 |
| 7.0.0-rc1 | 3 | 10/04/2023 |
| 7.0.0-preview2 | 11 | 07/21/2023 |
| 7.0.0-preview1 | 10 | 05/24/2023 |
| 7.0.0-beta1 | 4 | 09/25/2023 |
| 6.2.19 | 1 | 04/14/2024 |
| 6.2.18 | 2 | 03/13/2024 |
| 6.2.17 | 2 | 02/19/2024 |
| 6.2.16 | 4 | 01/13/2024 |
| 6.2.15 | 2 | 12/17/2023 |
| 6.2.14 | 6 | 12/06/2023 |
| 6.2.13 | 3 | 11/29/2023 |
| 6.2.12 | 7 | 11/09/2023 |
| 6.2.11 | 2 | 10/26/2023 |
| 6.2.10 | 5 | 10/04/2023 |
| 6.2.9 | 6 | 09/14/2023 |
| 6.2.8 | 7 | 09/14/2023 |
| 6.2.7 | 7 | 08/28/2023 |
| 6.2.6 | 5 | 06/18/2023 |
| 6.2.5 | 4 | 06/18/2023 |
| 6.2.4 | 8 | 05/17/2023 |
| 6.2.3 | 7 | 05/30/2023 |
| 6.2.2 | 5 | 06/18/2023 |
| 6.2.1 | 5 | 05/17/2023 |
| 6.2.0 | 5 | 06/18/2023 |
| 6.1.3 | 4 | 09/08/2023 |
| 6.1.2 | 4 | 05/17/2023 |
| 6.1.1 | 18 | 12/11/2022 |
| 6.1.0 | 15 | 11/30/2022 |
| 6.0.8 | 1,603 | 09/27/2022 |
| 6.0.7 | 13 | 09/09/2022 |
| 6.0.6 | 26 | 08/24/2022 |
| 6.0.5 | 10 | 09/02/2022 |
| 6.0.4 | 14 | 08/26/2022 |
| 6.0.3 | 14 | 06/30/2022 |
| 6.0.2-beta | 30 | 08/23/2022 |
| 6.0.1-beta | 10 | 07/25/2022 |
| 6.0.0-beta | 7 | 09/03/2022 |
| 5.8.14 | 10 | 06/18/2023 |
| 5.8.13 | 11 | 09/07/2022 |
| 5.8.12 | 20 | 08/04/2022 |
| 5.8.11 | 21 | 08/13/2022 |
| 5.8.10 | 15 | 08/13/2022 |
| 5.8.9 | 26 | 08/13/2022 |
| 5.8.8 | 10 | 08/13/2022 |
| 5.8.7 | 25 | 09/07/2022 |
| 5.8.6 | 21 | 06/30/2022 |
| 5.8.5 | 18 | 08/24/2022 |
| 5.8.4 | 9 | 08/25/2022 |
| 5.8.3 | 8 | 09/07/2022 |
| 5.8.2 | 13 | 09/02/2022 |
| 5.8.1 | 32 | 08/23/2022 |
| 5.8.0 | 34 | 07/25/2022 |
| 5.7.5 | 26 | 09/07/2022 |
| 5.7.4 | 14 | 09/02/2022 |
| 5.7.3 | 29 | 09/11/2022 |
| 5.7.2 | 29 | 09/07/2022 |
| 5.7.1 | 10 | 09/02/2022 |
| 5.7.0 | 11 | 08/25/2022 |
| 5.6.4 | 10 | 08/23/2022 |
| 5.6.3 | 10 | 08/23/2022 |
| 5.6.2 | 36 | 09/04/2022 |
| 5.6.1 | 9 | 09/02/2022 |
| 5.6.0 | 13 | 09/10/2022 |
| 5.5.5 | 18 | 07/13/2022 |
| 5.5.4 | 21 | 09/08/2022 |
| 5.5.3 | 27 | 09/07/2022 |
| 5.5.2 | 32 | 06/28/2022 |
| 5.5.1 | 7 | 09/05/2022 |
| 5.5.0 | 10 | 09/08/2022 |
| 5.4.2 | 12 | 08/23/2022 |
| 5.4.1 | 10 | 09/07/2022 |
| 5.4.0 | 35 | 09/10/2022 |
| 5.3.2 | 24 | 08/24/2022 |
| 5.3.1 | 10 | 08/13/2022 |
| 5.3.0 | 20 | 08/13/2022 |
| 5.2.1 | 18 | 07/01/2022 |
| 5.2.0 | 12 | 08/13/2022 |
| 5.1.2 | 9 | 08/19/2022 |
| 5.1.1 | 19 | 07/03/2022 |
| 5.1.0 | 12 | 07/25/2022 |
| 5.0.4 | 13 | 08/13/2022 |
| 5.0.3 | 14 | 08/13/2022 |
| 5.0.2-rc | 17 | 08/13/2022 |
| 5.0.1-beta | 17 | 08/13/2022 |
| 5.0.0-beta | 28 | 08/13/2022 |
| 4.5.3.3 | 1,814 | 06/27/2022 |
| 4.5.3.2 | 19 | 08/13/2022 |
| 4.5.3.1 | 30 | 08/13/2022 |
| 4.5.3 | 17 | 08/13/2022 |
| 4.5.2.1 | 27 | 08/13/2022 |
| 4.5.2 | 21 | 07/15/2022 |
| 4.5.1 | 24 | 08/13/2022 |
| 4.1.1 | 34 | 08/13/2022 |
| 4.1.0 | 28 | 07/03/2022 |
| 4.0.5 | 14 | 08/19/2022 |
| 4.0.4 | 9 | 08/19/2022 |
| 4.0.3 | 10 | 08/22/2022 |
| 4.0.2 | 10 | 08/18/2022 |
| 4.0.1.1 | 14 | 08/18/2022 |