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
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
|
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
导入导出通用库。
官方网址:http://xin-lai.com
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
小店地址:https://shop113059108.taobao.com/
|
4 |
BootstrapBlazor.TableExport
Bootstrap UI components for Blazor and Razor Components
|
3 |
BootstrapBlazor
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 |
Magicodes.IE.Excel
导入导出通用库。
官方网址:http://xin-lai.com
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
小店地址:https://shop113059108.taobao.com/
|
3 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
|
3 |
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}}
|
3 |
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)
|
3 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**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.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 进行采取兼容机制
|
3 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**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);`
**2020.06.07**
- ** 【Nuget】版本更新到2.2.4**
- ** 【Excel导入】增加`导入失败`仅返回错误行功能**
- ** 【Excel导入】修复导入的空行标注位置偏移**
- ** 【Excel导出】增加`SeparateByColumn`进行分割追加列**
|
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 |
.NET Framework 3.5
- EPPlus.Interfaces (>= 8.0.0)
.NET Standard 2.1
- System.Text.Encoding.CodePages (>= 8.0.0)
- System.Security.Cryptography.Xml (>= 8.0.2)
- System.Security.Cryptography.Pkcs (>= 8.0.1)
- System.ComponentModel.Annotations (>= 5.0.0)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
- Microsoft.Extensions.Configuration.Json (>= 8.0.1)
- EPPlus.Interfaces (>= 8.0.0)
.NET Standard 2.0
- System.Text.Encoding.CodePages (>= 8.0.0)
- System.Security.Cryptography.Xml (>= 8.0.2)
- System.Security.Cryptography.Pkcs (>= 8.0.1)
- System.ComponentModel.Annotations (>= 5.0.0)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
- Microsoft.Extensions.Configuration.Json (>= 8.0.1)
- EPPlus.Interfaces (>= 8.0.0)
.NET 9.0
- System.Text.Encoding.CodePages (>= 9.0.3)
- System.Security.Cryptography.Xml (>= 9.0.3)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Security.Cryptography.Pkcs (>= 9.0.3)
- EPPlus.Interfaces (>= 8.0.0)
- Microsoft.Extensions.Configuration.Json (>= 9.0.3)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
.NET Framework 4.6.2
- EPPlus.Interfaces (>= 8.0.0)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Security.Cryptography.Xml (>= 8.0.2)
.NET 8.0
- Microsoft.Extensions.Configuration.Json (>= 8.0.1)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
- EPPlus.Interfaces (>= 8.0.0)
- System.Security.Cryptography.Pkcs (>= 8.0.1)
- System.Security.Cryptography.Xml (>= 8.0.2)
- System.Text.Encoding.CodePages (>= 8.0.0)
- System.ComponentModel.Annotations (>= 5.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 | 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 | 2 | 2025/5/27 |
7.5.2 | 1 | 2025/5/26 |
7.5.1 | 1 | 2025/5/26 |
7.5.0 | 2 | 2025/5/26 |
7.4.2 | 1 | 2025/5/26 |
7.4.1 | 2 | 2025/5/26 |
7.4.0 | 2 | 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 | 3 | 2025/5/26 |
7.2.1 | 2 | 2025/5/26 |
7.2.0 | 2 | 2025/5/26 |
7.1.3 | 1 | 2025/5/26 |
7.1.2 | 2 | 2025/5/26 |
7.1.1 | 2 | 2025/5/26 |
7.1.0 | 2 | 2025/5/26 |
7.0.10 | 3 | 2025/5/28 |
7.0.9 | 4 | 2025/5/25 |
7.0.8 | 4 | 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 | 2 | 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 | 4 | 2025/5/26 |
6.2.16 | 2 | 2025/5/30 |
6.2.15 | 1 | 2025/5/26 |
6.2.14 | 2 | 2025/5/26 |
6.2.13 | 4 | 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 | 4 | 2025/5/27 |
6.2.8 | 3 | 2025/5/26 |
6.2.7 | 1 | 2025/5/26 |
6.2.6 | 4 | 2025/5/24 |
6.2.5 | 1 | 2025/5/27 |
6.2.4 | 2 | 2025/5/26 |
6.2.3 | 2 | 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 | 4 | 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 | 4 | 2025/5/25 |
5.8.13 | 1 | 2025/5/26 |
5.8.12 | 1 | 2025/5/26 |
5.8.11 | 2 | 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 | 2 | 2025/5/26 |
5.7.5 | 2 | 2025/5/26 |
5.7.4 | 1 | 2025/5/26 |
5.7.3 | 2 | 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 | 1 | 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 | 2 | 2025/5/26 |
5.5.3 | 2 | 2025/5/30 |
5.5.2 | 2 | 2025/5/26 |
5.5.1 | 3 | 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 | 2 | 2025/5/26 |
5.2.0 | 2 | 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 | 2 | 2025/4/17 |
4.5.3.1 | 4 | 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 | 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 | 3 | 2025/5/26 |
4.0.2 | 2 | 2025/5/26 |
4.0.1.1 | 1 | 2025/5/26 |