EPPlus 8.0.1

EPPlus 8

License

EPPlus 8 has a dual license model with a community license for noncommercial use: Polyform Noncommercial 1.0.0.

With this license EPPlus is free to use for personal or noncommercial use, but will require a commercial license to be used in a commercial business.

Commercial licenses, which includes support, can be purchased at (https://www.epplussoftware.com/).

The source code for EPPlus is available at EPPlus Software's github repository

License parameter must be set

Before using EPPlus 8, you must specify the license to use. This is done via the License property of the ExcelPackage class

For commercial use, you use the License.SetCommercial(string), with your license key as argument. Your license key is available on your license, under the section "My Licenses" on our website.

For noncommercial use, you set the License.SetNonCommercialOrganization(string) or License.SetNonCommercialPersonal(string) with the name as argument. Noncommercial use will reserve the Comment and Tag field of the package for license information and add a license file within the package.

You can also configure these settings in the configuration files or in an environment varialble:

1. Via code

// If you are a commercial business and have
// purchased commercial licenses use the static property
// LicenseContext of the ExcelPackage class :
ExcelPackage.License.SetCommercial("<Your License Key here>");

// If you use EPPlus in a noncommercial context
// according to the Polyform Noncommercial license:
ExcelPackage.License.SetNonCommercialPersonal("<Your Name>");
//or..
ExcelPackage.License.SetNonCommercialOrganization("<Your Noncommercial Organization>");
    
using(var package = new ExcelPackage(new FileInfo("MyWorkbook.xlsx")))
{

}

2. Via appSettings.json

{
    {
    "EPPlus": {
        "ExcelPackage": {
            "License": "Commercial:<Your License Key here>" //The license context used
            }
        }
    }
}

3. Via app/web.config

<appSettings>
    <!--The license context used-->
    <add key="EPPlus:ExcelPackage.License" value="NonCommercialPersonal:Your Name" /> //..or use "NonCommercialOrganization:Your Organizations name" 
</appSettings>

4. Set the environment variable 'EPPlusLicenseContext'

This might be the easiest way of configuring this. Just as above, set the variable EPPlusLicense.

New features in EPPlus 8

Support for OLE objects (Linked or Embedded files).
Support for digital signing workbooks and signature lines.
In-cell pictures / support for the IMAGE function.
Sensitivity Label API to integrate with MIP (Microsoft Information Protection SDK).
Many minor features and bug fixes.

Breaking Changes

See https://github.com/EPPlusSoftware/EPPlus/wiki/Breaking-Changes-in-EPPlus-8

Showing the top 20 packages that depend on EPPlus.

Packages	Downloads
Magicodes.IE.Excel 导入导出通用库。官方网址：http://xin-lai.com 开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032 小店地址：https://shop113059108.taobao.com/	9
Magicodes.IE.Excel 导入导出通用库。官方网址：http://xin-lai.com 开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032 小店地址：https://shop113059108.taobao.com/	6
Magicodes.IE.Excel 导入导出通用库，通过导入导出DTO模型来控制导入和导出，支持Excel、Word、Pdf和Html。开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032	6
BootstrapBlazor Bootstrap UI components for Blazor and Razor Components	5
BootstrapBlazor.TableExport Bootstrap UI components for Blazor and Razor Components	5
Magicodes.IE.Excel 导入导出通用库。官方网址：http://xin-lai.com 开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032 小店地址：https://shop113059108.taobao.com/	5
Magicodes.IE.Excel 导入导出通用库，通过导入导出DTO模型来控制导入和导出，支持Excel、Word、Pdf和Html。开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032	5
BootstrapBlazor.TableExport Bootstrap UI components extensions of export	5
BootstrapBlazor Bootstrap UI components for Blazor and Razor Components	4
BootstrapBlazor.TableExport Bootstrap UI components for Blazor and Razor Components	4
Magicodes.IE.Excel 导入导出通用库，通过导入导出DTO模型来控制导入和导出，支持Excel、Word、Csv、Pdf和Html以及动态导出。开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032 2020.07.14 - 【Nuget】版本更新到2.3.0-beta4 2020.07.13 - 【Nuget】版本更新到2.3.0-beta3 - 【PDF导出】修复Linux下导出PDf 出错问题 #125 2020.07.06 - 【Nuget】版本更新到2.3.0-beta2 - 【Excel导出】导出业务错误数据支持直接返回错误数据的文件流字节 - 【Excel导出】对追加sheet实现同一个Model可自定义传入不同sheet名称 - exporter.Append(list1,"sheet1").SeparateBySheet().Append(list2).ExportAppendData(filePath); - 【Nuget】针对于一些客户端不支持SemVer 2.0.0 进行采取兼容机制 2020.06.22 - 【Nuget】版本更新到2.3.0-beta1 - ** 【Excel导出】添加对Excel模板导出函数的支持 - {{Formula::AVERAGE?params=G4:G6}}	4
Magicodes.IE.Excel 导入导出通用库，通过导入导出DTO模型来控制导入和导出，支持Excel、Word、Csv、Pdf和Html以及动态导出。开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032 2020.08.10 - 【Nuget】版本更新到2.3.0-beta6 - 多Sheet导入保存标注错误单元测试，并没出现多数据导入效验bug #108 - Excel多Sheet 导入模板生成 #133 - 修复Excel模板图片高度问题 #131 2020.08.04 - 【Nuget】版本更新到2.3.0-beta5 - 在runtimes native包问题 - 对于跨平台native中 COM Interop is not supported on this platform. #130 2020.07.14 - 【Nuget】版本更新到2.3.0-beta4 2020.07.13 - 【Nuget】版本更新到2.3.0-beta3 - 【PDF导出】修复Linux下导出PDf 出错问题 #125 2020.07.06 - 【Nuget】版本更新到2.3.0-beta2 - 【Excel导出】导出业务错误数据支持直接返回错误数据的文件流字节 - 【Excel导出】对追加sheet实现同一个Model可自定义传入不同sheet名称 - exporter.Append(list1,"sheet1").SeparateBySheet().Append(list2).ExportAppendData(filePath); - 【Nuget】针对于一些客户端不支持SemVer 2.0.0 进行采取兼容机制	4
Magicodes.IE.Excel 导入导出通用库。官方网址：http://xin-lai.com 开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032 小店地址：https://shop113059108.taobao.com/	4
Magicodes.IE.Excel 导入导出通用库，通过导入导出DTO模型来控制导入和导出，支持Excel、Word、Csv、Pdf和Html以及动态导出。开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032 2.2.0-beta8 【Excel模板导出】支持图片 [#61](https://github.com/dotnetcore/Magicodes.IE/issues/61) 2.2.0-beta7 【Excel模板导出】修复渲染问题 [#51](https://github.com/dotnetcore/Magicodes.IE/issues/51)	4
Magicodes.IE.Excel 导入导出通用库，通过导入导出DTO模型来控制导入和导出，支持Excel、Word、Pdf和Html。开源库地址:https://github.com/xin-lai 博客地址：http://www.cnblogs.com/codelove/ 交流QQ群：85318032 - 【Nuget】版本更新到2.2.0-beta4 - 【Excel多Sheet导出】修复[#66](https://github.com/dotnetcore/Magicodes.IE/issues/66)，并添加单元测试	4

EPPlus 8.0.1 IMPORTANT NOTICE! From version 5 EPPlus changes the license 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. Earlier versions are still licensed LGPL. ## Version 8.0.1 * EPPlus 8 will require a license key for commercial licenses. * Support for OLE objects (Linked or Embedded files). * Support for digital signing workbooks and signature lines. * In-cell pictures / support for the IMAGE function. * Sensitivity Label API to integrate with MIP (Microsoft Information Protection SDK). * Bug fixes ## Version 7.7.0 * Fixed referenced packages versioning. * Minor bug fixes. ## Version 7.6.2 * Minor bug fixes. ## Version 7.6.1 * Minor bug fixes. Minor features: * Autofit columns optimaiztion. * Range Copy now supports fill. * EPPlus now rounds decimal numbers more true to Excels precision. * Added ExcelRange.IsEmpty method. * Shape adjustments points support. * ExcelRangeBase.BorderAround now override borders for adjacent cells. * InsertRange now returnes the new inserted range. * In-cell checkboxes now renders in the HTML export. * Improved API for Tables to access data via column names. ## Version 7.6.0 * Added target framework .NET 9. Removed out of support versions, .NET 6 and .NET 7. * Minor features and bug fixes. ## Version 7.5.3 * Minor features and bug fixes. ## Version 7.5.2 * Pivot tables could crash * Reading linked images was failed if a relation attribute existed but did not have a value. * Support for in-cell checkboxes. * Interfaces to integrate EPPlus with the MIP API to handle sensibility labels. * Minor features and bug fixes. ## Version 7.5.1 * Minor features and bug fixes. ## Version 7.5.0 * Added signatures to the EPPlus.dll's and the EPPlus Nuget package. * Added new properties RepeatItemLabels and InsertBlankRow to ExcelPivotTableField * Minor features and bug fixes. ## Version 7.4.2 * Minor features and bug fixes. ## Version 7.4.1 * Updated for vulnerability in System.Text.Json - Microsoft.Extensions.Configuration.Json 8.0.0 -> 8.0.1 ## Version 7.4.0 * Conditional formatting in Pivot Tables. * Support for linked pictures in drawings. * Added 2 new functions * Minor features and bug fixes. ## Version 7.3.2 * Minor features and bug fixes. ## Version 7.3.1 * Minor features and bug fixes. ## Version 7.3.0 * Added precision as displayed to formula calculation * Added 4 new functions * Bug fixes See ## Version 7.2.2 * Minor features and bug fixes. ## Version 7.2.1 * Bug fixes ## Version 7.2.0 * Pivot table calculation * Fetch calculated data via the GetPivotData method or the CalculatedData property on the ExcelPivotData. * Support for the GetPivotData function. * Import/Export of fixed width text files. * Html export now supports all conditional formattings (Added support for Icon sets and Data bars in 7.2). * Copy of drawings. * Transpose functionality added to many Copy, Import and Export function. * Bug fixes ## Version 7.1.3 * Bug fixes ## Version 7.1.2 * Bug fixes ## Version 7.1.1 * Bug fixes ## Version 7.1.0 * The html export now supports most conditional formattings. * Updated performance for rich text handling on ranges. * Improvments in sort order and cell formatting of the ExcelRangeBase.LoadFromCollection method * Bug fixes ## Version 7.0.10 * Bug fixes ## Version 7.0.9 * Bug fixes ## Version 7.0.8 * Bug fixes ## Version 7.0.7 * Bug fixes ## Version 7.0.6 * Bug fixes ## Version 7.0.5 * Bug fixes ## Version 7.0.4 * Bug fixes ## Version 7.0.3 * Bug fixes ## Version 7.0.2 * Bug fixes ## Version 7.0.1 * Bug fixes ## Version 7.0.0 * Calculation engine update to support array formulas. https://epplussoftware.com/en/Developers/EPPlus7 * Support for calculating legacy / dynamic array formulas. * Support for intersect operator. * Support for implicit intersection. * Support for array parameters in functions. * Better support for using the colon operator with functions. * Better handling of circular references * 90 new functions * Faster optimized calculation engine with configurable expression caching. * Breaking changes: Updated calculation engine, See [Breaking Changes in EPPlus 7](https://github.com/EPPlusSoftware/EPPlus/wiki/Breaking-Changes-in-EPPlus-7) for more information. * Conditional Formatting improvements * Improved performance, xml is now read and written on load and save. * Cross worksheet support formula support. * Extended styling options for color scales, data bars and icon sets. ## Version 6.2.13 * Bug fixes. ## Version 6.2.12 * Bug fixes. ## Version 6.2.11 * Bug fixes. ## Version 6.2.10 * Bug fixes. ## Version 6.2.9 * Bug fixes. ## Version 6.2.8 * Bug fixes. ## Version 6.2.7 * Bug fixes. ## Version 6.2.6 * Updated System.Security.Cryptography.Pkcs for security vulnerability in .NET 6 and 7. See https://github.com/dotnet/runtime/issues/87498 * Bug fixes. ## Version 6.2.5 * Bug fixes. ## Version 6.2.4 * Bug fixes. ## Version 6.2.3 * Bug fixes. ## Version 6.2.2 * Bug fixes. ## Version 6.2.1 * Bug fixes. ## Version 6.2.0 * Improved performance and better support for cross-worksheet references in data validations. * Bug fixes. ## Version 6.1.3 * Bug fixes. ## Version 6.1.2 * Bug fixes. ## Version 6.1.1 * Added Target framework .NET 7. * Add support for linking a cell to a chart title text * Bug fixes. https://epplussoftware.com/Developers/MinorFeaturesAndIssues ## Version 6.1.0 * Support for the Agile and V3 VBA signing. - https://github.com/EPPlusSoftware/EPPlus/wiki/VBA * ExcelRange.ToCollection method - to map ranges and tables to an collection of T - https://github.com/EPPlusSoftware/EPPlus/wiki/ToCollection * New methods to group, ungroup, collapse and expand rows and columns - https://github.com/EPPlusSoftware/EPPlus/wiki/Grouping-and-Ungrouping-Rows-and-Columns * New overloads of Drawings.AddPicture that reads the signature of the image from stream to identify the type of image. * AddPicture(string, Stream) * AddPicture(string, Stream, Uri) These overloads has been has been deprecated * AddPicture(string, Stream, ePictureType) * AddPicture(string, Stream, ePictureType, Uri) * Preserve the 'Table' formula properties (Created via the What-If analysis-Data Table). * Target framework .NET 5.0 has been removed as it is out of support by Microsoft. * Bug fixes. ## Version 6.0.8 * Bug fixes. ## Version 6.0.7 * Minor feature and Bug fixes. ## Version 6.0.6 * Bug fixes. ## Version 6.0.5 * Bug fixes. ## Version 6.0.4 * Bug fixes. ## Version 6.0.3 * Html Export - https://github.com/EPPlusSoftware/EPPlus/wiki/HTML-Export * Json Export - https://github.com/EPPlusSoftware/EPPlus/wiki/JSON-Export * 32 new functions. * Support for new image types: Svg, WebP and Ico. * Removed direct references to System.Drawing.Common, see https://github.com/EPPlusSoftware/EPPlus/wiki/Breaking-Changes-in-EPPlus-6 * Bug fixes. To see the new export in action, visit our new Web Sample Site: https://samples.epplussoftware.com See https://epplussoftware.com/Developers/EPPlus6 for more details. ## Version 5.8.10 * Bug fixes. ## Version 5.8.9 * Bug fixes. ## Version 5.8.8 * Bug fixes. ## Version 5.8.7 * Bug fixes. ## Version 5.8.6 * Bug fixes. ## Version 5.8.5 * Bug fixes. ## Version 5.8.4 * 10 new functions * Bug fixes. ## Version 5.8.3 * Bug fixes. ## Version 5.8.2 * Bug fixes. ## Version 5.8.1 * Bug fixes. ## Version 5.8.0 * ExcelWorksheetView.SplitPanes method added * ExcelRangeBase Fill method added * FillNumber * FillDateTime * FillList * New collection properties for Rows and Columns * ExcelWorksheet.Rows * ExcelWorksheet.Columns * ExcelRangeBase.EntireRow * ExcelRangeBase.EntireColum * Support for formatting and deleting individual Chart Legend Entries. * Range.Copy improvments. * Bug fixes ## Version 5.7.5 * Bug fixes. ## Version 5.7.4 * Bug fixes. ## Version 5.7.3 * Bug fixes. ## Version 5.7.2 * Bug fixes. ## Version 5.7.1 * Bug fixes. ## Version 5.7.0 * External links * Enhanced sorting * Table and auto filter sort state. * Horizontal sorting * Pivot table auto sort * Pivot tables - Support for Show Value As on data fields * Bug fixes. ## Version 5.6.4 * Bug fixes. ## Version 5.6.3 * Bug fixes. ## Version 5.6.2 * Bug fixes. ## Version 5.6.1 * Bug fixes. ## 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. ## 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 * LoadFromCollection changes the data type of parameter 'TableStyle' from 'TableStyles' to 'TableStyles?'. The default value, if omitted, changes from 'TableStyles.None' to null. 'TableStyles.None', if supplied will create a table with style None. * 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://github.com/EPPlusSoftware/EPPlus/wiki/Breaking-Changes-in-EPPlus-7 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-7 A list of fixed issues can be found here https://epplussoftware.com/docs/7.0/articles/fixedissues.html Version history 8.0.1 20250328 Digital Signatures, Ole objects, in-cell pictures. https://epplussoftware.com/en/Developers/EPPlus8 8.0.0-rc 20250321 Digital Signatures, Ole objects, in-cell pictures. 7.7.0 20250317 Fixed referenced packages versioning. Minor bug fixes. 8.0.0-beta 20250214 Digital Signatures, Ole objects, in-cell pictures. 7.6.1 20250304 Minor bug fixes. 7.6.0 20250206 Updated target frameworks. Minor features and bug fixes. 7.5.3 20250116 Minor features and bug fixes. 7.5.2 20241209 Minor features and bug fixes. 7.5.1 20241121 Minor features and bug fixes. 7.5.0 20241115 Signed dll's and nuget package. Minor features and bug fixes. 7.4.2 20241028 Minor features and bug fixes. 7.4.1 20241011 Updated System.Text.Json 7.4.0 20241002 Conditional Formatting's in Pivot tables. Linked image files in Pictures. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues 7.3.2 20240917 Minor features and bug fixes. 7.3.1 20240905 Minor features and bug fixes. 7.3.0 20240820 Precision as displayed support in formula calculation. 7.2.2 20240724 Minor features and bug fixes. 7.2.1 20240702 Minor bug fixes. 7.2.0 20240618 Pivot table calculation. Import/Export of fixed width text files. Improvment export of Conditional formatting. Copy of drawings. Transpose functionality. 7.1.3 20240528 Minor bug fixes. 7.1.2 20240423 Minor bug fixes. 7.1.1 20240408 Minor bug fixes. 7.1.0 20240328 Html export of Conditional formatting, Performance RichText, LoadFromCollection Enhancements. 7.0.10 20240311 Minor bug fixes. 7.0.9 20240215 Minor bug fixes. 7.0.8 20240124 Minor bug fixes. 7.0.7 20240119 Minor bug fixes. 7.0.6 20240110 Minor bug fixes. 7.0.5 20231222 Minor bug fixes. 7.0.4 20231215 Minor bug fixes. 7.0.3 20231205 Minor bug fixes. 7.0.2 20231123 Minor bug fixes. 7.0.1 20231109 Minor bug fixes. 7.0.0 20231026 Calculation engine update for array formulas. https://epplussoftware.com/en/Developers/EPPlus7 6.2.13 20231123 Minor bug fixes.See https://epplussoftware.com/Developers/MinorFeaturesAndIssues 6.2.12 20231026 Minor bug fixes. 6.2.11 20231023 Minor bug fixes. 7.0.0-rc 1 20231002 Calculation engine update for array formulas. 6.2.10 20231002 Minor bug fixes.See 7.0.0-beta 1 20230912 Calculation engine update for array formulas. 6.2.9 20230908 Minor bug fixes. 6.2.8 20230815 Minor bug fixes. 6.2.7 20230719 Minor bug fixes. 7.0.0-preview 2 20230719 Calculation engine update for array formulas. 6.2.6 20230615 Minor bug fixes. 6.2.5 20230614 Minor bug fixes. 7.0.0-preview 1 20230519 Calculation engine update for array formulas. 6.2.4 20230515 Minor bug fixes. 6.2.3 20230502 Minor bug fixes. 6.2.2 20230417 Minor bug fixes. 6.2.1 20230406 Minor bug fixes. 6.2.0 20230324 Performance update to data validation. Minor bug fixes. 6.1.3 20230224 Minor bug fixes. 6.1.2 20230119 Minor bug fixes. 6.1.1 20221121 Minor bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues 6.1.0 20221103 Newer types of VBA signatures, ToCollection method, Methods for Grouping rows and columns. 6.0.8 20220921 Minor bug fixes. 5.8.14 20220921 Minor bug fixes. 6.0.7 20220830 Minor bug fixes. 5.8.13 20220830 Minor bug fixes. 6.0.6 20220708 Minor bug fixes. 5.8.12 20220708 Minor bug fixes. 6.0.5 20220610 Minor bug fixes. 5.8.11 20220610 Minor bug fixes. 6.0.4 20220512 Minor bug fixes. 5.8.10 20220512 Minor bug fixes. 6.0.3 20220412 Html and JSON export. New drawing handling. https://epplussoftware.com/Developers/EPPlus6 5.8.9 20220411 Minor bug fixes. 5.8.8 20220322 Minor bug fixes. 6.0.1 20220310 Beta 2 6.0.0 20220307 Beta 1 5.8.7 20220301 Minor bug fixes. 5.8.6 20220203 Minor bug fixes. 5.8.5 20220113 Minor features and bug fixes. 5.8.4 20211214 Minor features and bug fixes. 5.8.3 20211119 Minor bug fixes. 5.8.2 20211029 Minor bug fixes. 5.8.1 20211026 Minor bug fixes. 5.8.0 20211021 Range.Fill methods, Range Rows and Column Collection, Range.Copy improvments and Worksheet Split Panes. 5.7.5 20210921 Minor bug fixes. 5.7.4 20210826 Minor bug fixes. 5.7.3 20210810 Minor bug fixes. 5.7.2 20210722 Minor bug fixes. 5.7.1 20210706 Minor bug fixes. 5.7.0 20210617 External links. Better sorting support. Pivot table ShowAs 5.6.4 20210512 Minor bug fixes. 5.6.3 20210416 Minor bug fixes. 5.6.2 20210407 Minor bug fixes. 5.6.1 20210322 Minor bug fixes. 5.6.0 20210315 Custom table styles. Pivot table styling. Table styling enhancements. 5.5.5 20210223 Minor bug fixes. 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

Version	Downloads	Last updated
8.0.5	5	2025/5/25
8.0.4	4	2025/5/24
8.0.3	5	2025/5/24
8.0.2	2	2025/5/26
8.0.1	2	2025/5/26
8.0.0-rc	1	2025/5/26
8.0.0-beta	1	2025/5/26
7.7.2	6	2025/5/24
7.7.1	1	2025/5/27
7.7.0	2	2025/5/26
7.6.1	1	2025/5/27
7.6.0	1	2025/5/26
7.5.3	4	2025/5/27
7.5.2	1	2025/5/26
7.5.1	1	2025/5/26
7.5.0	5	2025/5/26
7.4.2	1	2025/5/26
7.4.1	5	2025/5/26
7.4.0	4	2025/5/27
7.3.2	4	2025/5/24
7.3.1	1	2025/5/26
7.3.0	1	2025/5/26
7.2.2	5	2025/5/26
7.2.1	2	2025/5/26
7.2.0	3	2025/5/26
7.1.3	1	2025/5/26
7.1.2	5	2025/5/26
7.1.1	2	2025/5/26
7.1.0	2	2025/5/26
7.0.10	4	2025/5/28
7.0.9	5	2025/5/25
7.0.8	5	2025/5/26
7.0.7	3	2025/5/26
7.0.6	1	2025/5/26
7.0.5	1	2025/5/26
7.0.4	3	2025/5/26
7.0.3	1	2025/5/26
7.0.2	1	2025/5/26
7.0.1	1	2025/5/26
7.0.0	1	2025/5/26
6.2.19	2	2025/5/26
6.2.18	1	2025/5/26
6.2.17	5	2025/5/26
6.2.16	3	2025/5/30
6.2.15	2	2025/5/26
6.2.14	4	2025/5/26
6.2.13	5	2025/5/24
6.2.12	1	2025/5/27
6.2.11	1	2025/5/26
6.2.10	2	2025/5/26
6.2.9	4	2025/5/27
6.2.8	3	2025/5/26
6.2.7	1	2025/5/26
6.2.6	8	2025/5/24
6.2.5	1	2025/5/27
6.2.4	3	2025/5/26
6.2.3	4	2025/5/26
6.2.2	1	2025/5/26
6.2.1	3	2025/5/26
6.2.0	1	2025/5/26
6.1.3	1	2025/5/26
6.1.2	1	2025/5/26
6.1.1	4	2025/5/22
6.1.0	1	2025/5/26
6.0.8	6	2025/5/26
6.0.7	1	2025/5/26
6.0.6	2	2025/5/27
6.0.5	1	2025/5/26
6.0.4	5	2025/5/26
6.0.3	3	2025/5/26
5.8.14	7	2025/5/25
5.8.13	1	2025/5/26
5.8.12	1	2025/5/26
5.8.11	3	2025/5/27
5.8.10	2	2025/4/17
5.8.9	1	2025/4/17
5.8.8	1	2025/5/26
5.8.7	1	2025/5/26
5.8.6	3	2025/5/25
5.8.5	1	2025/5/30
5.8.4	1	2025/5/26
5.8.3	1	2025/5/26
5.8.2	1	2025/5/26
5.8.1	1	2025/5/26
5.8.0	4	2025/5/26
5.7.5	2	2025/5/26
5.7.4	1	2025/5/26
5.7.3	4	2025/5/30
5.7.2	2	2025/5/30
5.7.1	2	2025/5/26
5.7.0	1	2025/5/26
5.6.4	1	2025/5/26
5.6.3	1	2025/5/26
5.6.2	2	2025/5/26
5.6.1	2	2025/5/30
5.6.0	1	2025/5/26
5.5.5	1	2025/5/26
5.5.4	4	2025/5/26
5.5.3	6	2025/5/30
5.5.2	3	2025/5/26
5.5.1	4	2025/5/26
5.5.0	2	2025/5/26
5.4.2	2	2025/5/26
5.4.1	2	2025/5/26
5.4.0	2	2025/5/26
5.3.2	4	2025/5/30
5.3.1	1	2025/5/26
5.3.0	1	2025/5/30
5.2.1	3	2025/5/26
5.2.0	3	2025/5/26
5.1.2	1	2025/5/26
5.1.1	1	2025/5/26
5.1.0	2	2025/5/26
5.0.4	2	2025/5/26
5.0.3	1	2025/5/30
4.5.3.3	2	2025/5/26
4.5.3.2	4	2025/4/17
4.5.3.1	5	2025/5/25
4.5.3	2	2025/5/26
4.5.2.1	2	2025/5/26
4.5.2	1	2025/5/26
4.5.1	2	2025/5/26
4.1.1	1	2025/5/26
4.1.0	3	2025/5/24
4.0.5	2	2025/5/26
4.0.4	2	2025/4/27
4.0.3	4	2025/5/26
4.0.2	2	2025/5/26
4.0.1.1	1	2025/5/26

EPPlus 8.0.1

Readme

EPPlus 8

License

License parameter must be set

1. Via code

2. Via appSettings.json

3. Via app/web.config

4. Set the environment variable 'EPPlusLicenseContext'

New features in EPPlus 8

Breaking Changes

Used By

Release Notes

Dependencies

.NET Framework 3.5

.NET Standard 2.1

.NET Standard 2.0

.NET 9.0

.NET Framework 4.6.2

.NET 8.0

Versions