EPPlus 6.2.14
EPPlus 6
Announcement: new license model from version 5
EPPlus has from this new major version changed license from LGPL to Polyform Noncommercial 1.0.0.
With the new license EPPlus is still free to use in some cases, but will require a commercial license to be used in a commercial business.
This is explained in more detail here.
Commercial licenses, which includes support, can be purchased at (https://www.epplussoftware.com/).
The source code of EPPlus has moved to a new github repository
LicenseContext parameter must be set
With the license change EPPlus has a new parameter that needs to be configured. If the LicenseContext is not set, EPPlus will throw a LicenseException (only in debug mode).
This is a simple configuration that can be set in a few alternative ways:
1. Via code
// If you are a commercial business and have
// purchased commercial licenses use the static property
// LicenseContext of the ExcelPackage class :
ExcelPackage.LicenseContext = LicenseContext.Commercial;
// If you use EPPlus in a noncommercial context
// according to the Polyform Noncommercial license:
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using(var package = new ExcelPackage(new FileInfo("MyWorkbook.xlsx")))
{
}
2. Via appSettings.json
{
{
"EPPlus": {
"ExcelPackage": {
"LicenseContext": "Commercial" //The license context used
}
}
}
}
3. Via app/web.config
<appSettings>
<!--The license context used-->
<add key="EPPlus:ExcelPackage.LicenseContext" value="NonCommercial" />
</appSettings>
4. Set the environment variable 'EPPlusLicenseContext'
This might be the easiest way of configuring this. Just as above, set the variable to Commercial or NonCommercial depending on your usage.
Important! The environment variable should be set at the user or process level.
New features in EPPlus 6
EPPlus 6 comes with a set of new features, see (https://www.epplussoftware.com/Developers/Features)
Breaking Changes
- From version 6.2, updating data validations via the XML DOM will not work as read and write is performed on load/save. ExcelDataValidation.IsStale is deprecated and will always return false.
- All public references to System.Drawing.Common has been removed from EPPlus. See Breaking Changes in EPPlus 6.
- Static class 'FontSize' has splitted width and heights into two dictionaries. FontSizes are lazy-loaded when needed.
- ...and more, see https://epplussoftware.com/docs/6.0/articles/breakingchanges.html
Breaking Changes in version 5.
- 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".
Improved documentation
EPPlus 6 has a new web sample site available here: (https://samples.epplussoftware.com/) , Source code is available here: EPPlus.WebSamples There is also a new sample project for four different docker images, EPPlus.DockerSample EPPlus also has two separate sample projects for .NET Core and .NET Framework respectively. There is also an updated developer wiki. The work with improving the documentation will continue, feedback is highly appreciated!
Showing the top 20 packages that depend on EPPlus.
| Packages | Downloads |
|---|---|
|
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**2020.06.22**
- ** 【Nuget】版本更新到3.0.0-beta1**
- ** 【Excel导出】添加对Excel模板导出函数的支持
- {{Formula::AVERAGE?params=G4:G6}}
**2020.06.17**
- ** 【Nuget】版本更新到2.2.7**
- ** 【HTML导出】添加对NETCore2.2模板引擎的支持
**2020.06.16**
- ** 【Nuget】版本更新到2.2.6**
- ** 【HTML导出】添加对NETCore2.2模板引擎的支持
**2020.06.14**
- ** 【Nuget】版本更新到2.2.5**
- ** 【Excel导出】增加分栏、分sheet、追加rows导出 [#74](https://github.com/dotnetcore/Magicodes.IE/issues/74)**
- exporter.Append(list1).SeparateByColumn().Append(list2).ExportAppendData(filePath);
- exporter.Append(list1).SeparateBySheet().Append(list2).ExportAppendData(filePath);
- exporter.Append(list1).SeparateByRow().AppendHeaders().Append(list2).ExportAppendData(filePath);
- ** [Excel导出】修复‘IsAllowRepeat=true’ [#107](https://github.com/dotnetcore/Magicodes.IE/issues/107) **
- ** [Pdf导出】增加PDF扩展方法,支持通过以参数形式传递特性参数 [#104](https://github.com/dotnetcore/Magicodes.IE/issues/104) **
- `ExportListBytesByTemplate<T>(ICollection<T> data, PdfExporterAttribute pdfExporterAttribute,string temple);`
- `ExportBytesByTemplate<T>(T data, PdfExporterAttribute pdfExporterAttribute,string template);`
|
2 |
|
Magicodes.IE.Excel
导入导出通用库。
官方网址:http://xin-lai.com
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
小店地址:https://shop113059108.taobao.com/
|
2 |
|
BootstrapBlazor
Bootstrap UI components for Blazor and Razor Components
|
2 |
|
PdfRpt.Core
PdfReport.Core is a code first reporting engine, which is built on top of the iTextSharp.LGPLv2.Core and EPPlus.Core libraries.
|
2 |
|
Magicodes.IE.Excel
导入导出通用库。
官方网址:http://xin-lai.com
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
小店地址:https://shop113059108.taobao.com/
|
1 |
|
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**2020.06.07**
- ** 【Nuget】版本更新到2.2.4**
- ** 【Excel导入】增加`导入失败`仅返回错误行功能**
- ** 【Excel导入】修复导入的空行标注位置偏移**
- ** 【Excel导出】增加`SeparateByColumn`进行分割追加列**
**2020.05.31**
- **【Nuget】版本更新到2.2.3**
- **【Excel导入】增加了stream Csv导入扩展方法
- **【Word导出】修复word文件字节导出错误
**2020.05.24**
- **【Nuget】版本更新到2.2.2**
- **【Excel导入】增加了stream导入扩展方法
- **【Excel导出】增加了内容居中(单列居中、整表居中)
- **【导出】对一些中间件代码进行了修复及优化
|
1 |
|
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
|
1 |
|
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**2020.06.14**
- ** 【Nuget】版本更新到2.2.5**
- ** 【Excel导出】增加分栏、分sheet、追加rows导出 [#74](https://github.com/dotnetcore/Magicodes.IE/issues/74)**
- exporter.Append(list1).SeparateByColumn().Append(list2).ExportAppendData(filePath);
- exporter.Append(list1).SeparateBySheet().Append(list2).ExportAppendData(filePath);
- exporter.Append(list1).SeparateByRow().AppendHeaders().Append(list2).ExportAppendData(filePath);
- ** [Excel导出】修复‘IsAllowRepeat=true’ [#107](https://github.com/dotnetcore/Magicodes.IE/issues/107) **
- ** [Pdf导出】增加PDF扩展方法,支持通过以参数形式传递特性参数 [#104](https://github.com/dotnetcore/Magicodes.IE/issues/104) **
- `ExportListBytesByTemplate<T>(ICollection<T> data, PdfExporterAttribute pdfExporterAttribute,string temple);`
- `ExportBytesByTemplate<T>(T data, PdfExporterAttribute pdfExporterAttribute,string template);`
**2020.06.07**
- ** 【Nuget】版本更新到2.2.4**
- ** 【Excel导入】增加`导入失败`仅返回错误行功能**
- ** 【Excel导入】修复导入的空行标注位置偏移**
- ** 【Excel导出】增加`SeparateByColumn`进行分割追加列**
**2020.05.31**
- **【Nuget】版本更新到2.2.3**
- **【Excel导入】增加了stream Csv导入扩展方法
- **【Word导出】修复word文件字节导出错误
|
1 |
.NET Framework 3.5
- EPPlus.Interfaces (>= 6.1.1)
- EPPlus.System.Drawing (>= 6.1.1)
.NET Framework 4.6.2
- EPPlus.Interfaces (>= 6.1.1)
- EPPlus.System.Drawing (>= 6.1.1)
- Microsoft.IO.RecyclableMemoryStream (>= 1.4.1)
.NET 6.0
- EPPlus.Interfaces (>= 6.1.1)
- EPPlus.System.Drawing (>= 6.1.1)
- Microsoft.Extensions.Configuration.Json (>= 6.0.0)
- Microsoft.IO.RecyclableMemoryStream (>= 2.2.1)
- System.Security.Cryptography.Pkcs (>= 6.0.4)
- System.Text.Encoding.CodePages (>= 6.0.0)
.NET 7.0
- EPPlus.Interfaces (>= 6.1.1)
- EPPlus.System.Drawing (>= 6.1.1)
- Microsoft.Extensions.Configuration.Json (>= 7.0.0)
- Microsoft.IO.RecyclableMemoryStream (>= 2.2.1)
- System.Security.Cryptography.Pkcs (>= 7.0.3)
- System.Text.Encoding.CodePages (>= 7.0.0)
.NET Standard 2.0
- EPPlus.Interfaces (>= 6.1.1)
- EPPlus.System.Drawing (>= 6.1.1)
- Microsoft.Extensions.Configuration.Json (>= 2.1.1)
- Microsoft.IO.RecyclableMemoryStream (>= 2.2.1)
- System.Drawing.Primitives (>= 4.3.0)
- System.Security.Cryptography.Pkcs (>= 4.7.0)
- System.Text.Encoding.CodePages (>= 4.7.1)
.NET Standard 2.1
- EPPlus.Interfaces (>= 6.1.1)
- EPPlus.System.Drawing (>= 6.1.1)
- Microsoft.Extensions.Configuration.Json (>= 3.1.32)
- Microsoft.IO.RecyclableMemoryStream (>= 2.2.1)
- System.Drawing.Primitives (>= 4.3.0)
- System.Security.Cryptography.Pkcs (>= 4.7.0)
- System.Text.Encoding.CodePages (>= 4.7.1)
| Version | Downloads | Last updated |
|---|---|---|
| 8.3.1 | 1 | 2025/12/6 |
| 8.3.0 | 0 | 2025/11/20 |
| 8.2.1 | 2 | 2025/11/18 |
| 8.2.0 | 1 | 2025/11/18 |
| 8.1.1 | 1 | 2025/11/18 |
| 8.1.0 | 2 | 2025/8/21 |
| 8.0.8 | 3 | 2025/8/21 |
| 8.0.7 | 2 | 2025/8/21 |
| 8.0.6 | 2 | 2025/8/21 |
| 8.0.5 | 6 | 2025/6/19 |
| 8.0.4 | 2 | 2025/8/21 |
| 8.0.3 | 2 | 2025/8/21 |
| 8.0.2 | 4 | 2025/6/3 |
| 8.0.1 | 2 | 2025/8/21 |
| 8.0.0-rc | 2 | 2025/8/25 |
| 8.0.0-beta | 2 | 2025/8/25 |
| 7.7.3 | 2 | 2025/8/20 |
| 7.7.2 | 2 | 2025/8/21 |
| 7.7.1 | 2 | 2025/8/21 |
| 7.7.0 | 2 | 2025/8/21 |
| 7.6.1 | 2 | 2025/8/21 |
| 7.6.0 | 2 | 2025/8/21 |
| 7.5.3 | 2 | 2025/8/21 |
| 7.5.2 | 2 | 2025/8/21 |
| 7.5.1 | 2 | 2025/8/21 |
| 7.5.0 | 2 | 2025/8/21 |
| 7.4.2 | 2 | 2025/8/19 |
| 7.4.1 | 2 | 2025/8/21 |
| 7.4.0 | 2 | 2025/8/21 |
| 7.3.2 | 2 | 2025/8/21 |
| 7.3.1 | 2 | 2025/8/21 |
| 7.3.0 | 2 | 2025/8/21 |
| 7.2.2 | 2 | 2025/8/21 |
| 7.2.1 | 2 | 2025/8/21 |
| 7.2.0 | 2 | 2025/8/21 |
| 7.1.3 | 2 | 2025/8/21 |
| 7.1.2 | 2 | 2025/8/21 |
| 7.1.1 | 2 | 2025/8/21 |
| 7.1.0 | 2 | 2025/8/21 |
| 7.0.10 | 2 | 2025/8/20 |
| 7.0.9 | 3 | 2025/6/10 |
| 7.0.8 | 3 | 2025/8/21 |
| 7.0.7 | 2 | 2025/8/21 |
| 7.0.6 | 2 | 2025/8/21 |
| 7.0.5 | 2 | 2025/8/21 |
| 7.0.4 | 2 | 2025/8/21 |
| 7.0.3 | 2 | 2025/8/21 |
| 7.0.2 | 2 | 2025/8/21 |
| 7.0.1 | 2 | 2025/8/21 |
| 7.0.0 | 2 | 2025/8/21 |
| 6.2.19 | 2 | 2025/8/20 |
| 6.2.18 | 2 | 2025/8/20 |
| 6.2.17 | 2 | 2025/8/20 |
| 6.2.16 | 2 | 2025/8/20 |
| 6.2.15 | 2 | 2025/8/20 |
| 6.2.14 | 2 | 2025/8/20 |
| 6.2.13 | 2 | 2025/8/20 |
| 6.2.12 | 2 | 2025/8/20 |
| 6.2.11 | 2 | 2025/8/20 |
| 6.2.10 | 2 | 2025/8/20 |
| 6.2.9 | 2 | 2025/8/21 |
| 6.2.8 | 2 | 2025/8/21 |
| 6.2.7 | 2 | 2025/8/21 |
| 6.2.6 | 2 | 2025/8/21 |
| 6.2.5 | 2 | 2025/8/21 |
| 6.2.4 | 2 | 2025/8/21 |
| 6.2.3 | 2 | 2025/8/21 |
| 6.2.2 | 2 | 2025/8/21 |
| 6.2.1 | 2 | 2025/8/21 |
| 6.2.0 | 2 | 2025/8/21 |
| 6.1.3 | 2 | 2025/8/21 |
| 6.1.2 | 2 | 2025/8/21 |
| 6.1.1 | 2 | 2025/8/21 |
| 6.1.0 | 2 | 2025/8/21 |
| 6.0.8 | 2 | 2025/8/21 |
| 6.0.7 | 3 | 2025/6/10 |
| 6.0.6 | 2 | 2025/8/21 |
| 6.0.5 | 2 | 2025/8/21 |
| 6.0.4 | 2 | 2025/8/21 |
| 6.0.3 | 2 | 2025/8/21 |
| 5.8.14 | 2 | 2025/8/20 |
| 5.8.13 | 2 | 2025/8/20 |
| 5.8.12 | 2 | 2025/8/20 |
| 5.8.11 | 3 | 2025/8/20 |
| 5.8.10 | 2 | 2025/8/20 |
| 5.8.9 | 2 | 2025/8/21 |
| 5.8.8 | 2 | 2025/8/19 |
| 5.8.7 | 2 | 2025/8/19 |
| 5.8.6 | 2 | 2025/8/21 |
| 5.8.5 | 2 | 2025/8/21 |
| 5.8.4 | 2 | 2025/8/21 |
| 5.8.3 | 2 | 2025/8/21 |
| 5.8.2 | 2 | 2025/8/21 |
| 5.8.1 | 2 | 2025/8/21 |
| 5.8.0 | 3 | 2025/8/21 |
| 5.7.5 | 2 | 2025/8/21 |
| 5.7.4 | 2 | 2025/8/21 |
| 5.7.3 | 2 | 2025/8/21 |
| 5.7.2 | 2 | 2025/8/21 |
| 5.7.1 | 2 | 2025/8/21 |
| 5.7.0 | 2 | 2025/8/21 |
| 5.6.4 | 3 | 2025/6/10 |
| 5.6.3 | 2 | 2025/8/21 |
| 5.6.2 | 2 | 2025/8/21 |
| 5.6.1 | 2 | 2025/8/21 |
| 5.6.0 | 2 | 2025/8/21 |
| 5.5.5 | 1 | 2025/11/17 |
| 5.5.4 | 2 | 2025/8/21 |
| 5.5.3 | 2 | 2025/8/20 |
| 5.5.2 | 2 | 2025/8/21 |
| 5.5.1 | 2 | 2025/8/21 |
| 5.5.0 | 2 | 2025/8/21 |
| 5.4.2 | 2 | 2025/8/21 |
| 5.4.1 | 2 | 2025/8/21 |
| 5.4.0 | 2 | 2025/8/21 |
| 5.3.2 | 2 | 2025/8/21 |
| 5.3.1 | 2 | 2025/8/21 |
| 5.3.0 | 2 | 2025/8/21 |
| 5.2.1 | 2 | 2025/8/21 |
| 5.2.0 | 2 | 2025/8/21 |
| 5.1.2 | 2 | 2025/8/21 |
| 5.1.1 | 2 | 2025/8/21 |
| 5.1.0 | 2 | 2025/8/21 |
| 5.0.4 | 2 | 2025/8/21 |
| 5.0.3 | 2 | 2025/8/21 |
| 4.5.3.3 | 2 | 2025/8/25 |
| 4.5.3.2 | 5 | 2025/7/26 |
| 4.5.3.1 | 2 | 2025/8/25 |
| 4.5.3 | 2 | 2025/8/21 |
| 4.5.2.1 | 2 | 2025/8/25 |
| 4.5.2 | 2 | 2025/8/21 |
| 4.5.1 | 2 | 2025/8/21 |
| 4.1.1 | 2 | 2025/8/21 |
| 4.1.0 | 2 | 2025/8/21 |
| 4.0.5 | 2 | 2025/8/21 |
| 4.0.4 | 2 | 2025/8/21 |
| 4.0.3 | 2 | 2025/8/21 |
| 4.0.2 | 2 | 2025/8/21 |
| 4.0.1.1 | 2 | 2025/8/25 |