EPPlus 7.1.0
EPPlus 7
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 7
* 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.
Breaking Changes
See https://github.com/EPPlusSoftware/EPPlus/wiki/Breaking-Changes-in-EPPlus-7
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 |
---|---|
BootstrapBlazor
Bootstrap UI components for Blazor and Razor Components
|
4 |
BootstrapBlazor.TableExport
Bootstrap UI components for Blazor and Razor Components
|
4 |
BootstrapBlazor.TableExport
Bootstrap UI components for Blazor and Razor Components
|
3 |
EPPlus.Core.Extensions
An extensions library for both EPPlus and EPPlus.Core packages to generate and manipulate Excel files easily.
|
3 |
BootstrapBlazor
Bootstrap UI components for Blazor and Razor Components
|
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 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
|
2 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**2020.04.16**
- **【Nuget】版本更新到2.2.0-beta9**
- **【Excel模板导出】修复只存在一列时的导出 [#73](https://github.com/dotnetcore/Magicodes.IE/issues/73)**
- **【Excel导入】支持返回表头和索引 [#76](https://github.com/dotnetcore/Magicodes.IE/issues/76)**
- **【Excel导入导入】[#63](https://github.com/dotnetcore/Magicodes.IE/issues/63)**
- 支持使用System.ComponentModel.DataAnnotations命名空间下的部分特性来控制导入导出,比如
- DisplayAttribute
- DisplayFormatAttribute
- DescriptionAttribute
- 封装简单的易于使用的单一特性,例如
- IEIgnoreAttribute(可作用于属性、枚举成员,可影响导入和导出)
**2020.04.02**
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)
|
2 |
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)
|
2 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**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}}
**2020.06.17**
- ** 【Nuget】版本更新到2.2.7**
- ** 【HTML导出】添加对NETCore2.2模板引擎的支持
**2020.06.16**
- ** 【Nuget】版本更新到2.2.6**
- ** 【HTML导出】添加对NETCore2.2模板引擎的支持
|
2 |
BootstrapBlazor.TableExport
Bootstrap UI components extensions of export
|
2 |
.NET Framework 3.5
- EPPlus.Interfaces (>= 6.1.1)
- EPPlus.System.Drawing (>= 6.1.1)
.NET 8.0
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Text.Encoding.CodePages (>= 8.0.0)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.0)
- Microsoft.Extensions.Configuration.Json (>= 8.0.0)
- System.Security.Cryptography.Pkcs (>= 8.0.0)
- EPPlus.Interfaces (>= 6.1.1)
- EPPlus.System.Drawing (>= 6.1.1)
.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 (>= 3.0.0)
- System.ComponentModel.Annotations (>= 5.0.0)
- 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 (>= 3.0.0)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Drawing.Primitives (>= 4.3.0)
- System.Security.Cryptography.Pkcs (>= 4.7.0)
- System.Text.Encoding.CodePages (>= 4.7.1)
.NET Framework 4.6.2
- EPPlus.Interfaces (>= 6.1.1)
- EPPlus.System.Drawing (>= 6.1.1)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.0)
- System.ComponentModel.Annotations (>= 5.0.0)
.NET 6.0
- EPPlus.Interfaces (>= 6.1.1)
- Microsoft.Extensions.Configuration.Json (>= 6.0.0)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.0)
- System.ComponentModel.Annotations (>= 5.0.0)
- EPPlus.System.Drawing (>= 6.1.1)
- System.Text.Encoding.CodePages (>= 6.0.0)
- System.Security.Cryptography.Pkcs (>= 6.0.4)
.NET 7.0
- System.Security.Cryptography.Pkcs (>= 7.0.3)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Text.Encoding.CodePages (>= 7.0.0)
- Microsoft.Extensions.Configuration.Json (>= 7.0.0)
- EPPlus.System.Drawing (>= 6.1.1)
- EPPlus.Interfaces (>= 6.1.1)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.0)
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 | 1 | 2025/5/26 |
8.0.0-rc | 1 | 2025/5/26 |
8.0.0-beta | 1 | 2025/5/26 |
7.7.2 | 4 | 2025/5/24 |
7.7.1 | 1 | 2025/5/27 |
7.7.0 | 1 | 2025/5/26 |
7.6.1 | 1 | 2025/5/27 |
7.6.0 | 1 | 2025/5/26 |
7.5.3 | 1 | 2025/5/27 |
7.5.2 | 1 | 2025/5/26 |
7.5.1 | 1 | 2025/5/26 |
7.5.0 | 1 | 2025/5/26 |
7.4.2 | 1 | 2025/5/26 |
7.4.1 | 1 | 2025/5/26 |
7.4.0 | 1 | 2025/5/27 |
7.3.2 | 3 | 2025/5/24 |
7.3.1 | 1 | 2025/5/26 |
7.3.0 | 1 | 2025/5/26 |
7.2.2 | 1 | 2025/5/26 |
7.2.1 | 1 | 2025/5/26 |
7.2.0 | 1 | 2025/5/26 |
7.1.3 | 1 | 2025/5/26 |
7.1.2 | 1 | 2025/5/26 |
7.1.1 | 2 | 2025/5/26 |
7.1.0 | 1 | 2025/5/26 |
7.0.10 | 1 | 2025/5/28 |
7.0.9 | 3 | 2025/5/25 |
7.0.8 | 2 | 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 | 1 | 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 | 1 | 2025/5/26 |
6.2.18 | 1 | 2025/5/26 |
6.2.17 | 1 | 2025/5/26 |
6.2.16 | 1 | 2025/5/30 |
6.2.15 | 1 | 2025/5/26 |
6.2.14 | 1 | 2025/5/26 |
6.2.13 | 3 | 2025/5/24 |
6.2.12 | 1 | 2025/5/27 |
6.2.11 | 1 | 2025/5/26 |
6.2.10 | 1 | 2025/5/26 |
6.2.9 | 2 | 2025/5/27 |
6.2.8 | 1 | 2025/5/26 |
6.2.7 | 1 | 2025/5/26 |
6.2.6 | 3 | 2025/5/24 |
6.2.5 | 1 | 2025/5/27 |
6.2.4 | 1 | 2025/5/26 |
6.2.3 | 1 | 2025/5/26 |
6.2.2 | 1 | 2025/5/26 |
6.2.1 | 1 | 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 | 1 | 2025/5/26 |
6.0.7 | 1 | 2025/5/26 |
6.0.6 | 1 | 2025/5/27 |
6.0.5 | 1 | 2025/5/26 |
6.0.4 | 1 | 2025/5/26 |
6.0.3 | 1 | 2025/5/26 |
5.8.14 | 2 | 2025/5/25 |
5.8.13 | 1 | 2025/5/26 |
5.8.12 | 1 | 2025/5/26 |
5.8.11 | 1 | 2025/5/27 |
5.8.10 | 1 | 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 | 1 | 2025/5/26 |
5.7.5 | 2 | 2025/5/26 |
5.7.4 | 1 | 2025/5/26 |
5.7.3 | 1 | 2025/5/30 |
5.7.2 | 1 | 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 | 1 | 2025/5/26 |
5.6.1 | 1 | 2025/5/30 |
5.6.0 | 1 | 2025/5/26 |
5.5.5 | 1 | 2025/5/26 |
5.5.4 | 1 | 2025/5/26 |
5.5.3 | 1 | 2025/5/30 |
5.5.2 | 1 | 2025/5/26 |
5.5.1 | 1 | 2025/5/26 |
5.5.0 | 1 | 2025/5/26 |
5.4.2 | 2 | 2025/5/26 |
5.4.1 | 1 | 2025/5/26 |
5.4.0 | 1 | 2025/5/26 |
5.3.2 | 1 | 2025/5/30 |
5.3.1 | 1 | 2025/5/26 |
5.3.0 | 1 | 2025/5/30 |
5.2.1 | 1 | 2025/5/26 |
5.2.0 | 1 | 2025/5/26 |
5.1.2 | 1 | 2025/5/26 |
5.1.1 | 1 | 2025/5/26 |
5.1.0 | 1 | 2025/5/26 |
5.0.4 | 2 | 2025/5/26 |
5.0.3 | 1 | 2025/5/30 |
4.5.3.3 | 1 | 2025/5/26 |
4.5.3.2 | 2 | 2025/4/17 |
4.5.3.1 | 3 | 2025/5/25 |
4.5.3 | 2 | 2025/5/26 |
4.5.2.1 | 1 | 2025/5/26 |
4.5.2 | 1 | 2025/5/26 |
4.5.1 | 1 | 2025/5/26 |
4.1.1 | 1 | 2025/5/26 |
4.1.0 | 3 | 2025/5/24 |
4.0.5 | 1 | 2025/5/26 |
4.0.4 | 2 | 2025/4/27 |
4.0.3 | 2 | 2025/5/26 |
4.0.2 | 2 | 2025/5/26 |
4.0.1.1 | 1 | 2025/5/26 |