# 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](https://polyformproject.org/licenses/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](https://www.epplussoftware.com/Home/LgplToPolyform).
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](https://github.com/EPPlusSoftware/EPPlus)
## 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
```csharp
// 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
```json
{
{
"EPPlus": {
"ExcelPackage": {
"LicenseContext": "Commercial" //The license context used
}
}
}
}
```
### 3. Via app/web.config
```xml
<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](https://github.com/EPPlusSoftware/EPPlus/wiki/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](https://github.com/EPPlusSoftware/EPPlus.WebSamples)
There is also a new sample project for four different docker images, [EPPlus.DockerSample](https://github.com/EPPlusSoftware/EPPlus.DockerSample)
EPPlus also has two separate sample projects for [.NET Core](https://github.com/EPPlusSoftware/EPPlus.Sample.NetCore/tree/version/EPPlus6.0) and [.NET Framework](https://github.com/EPPlusSoftware/EPPlus.Sample.NetFramework/tree/version/EPPlus6.0) respectively.
There is also an updated [developer wiki](https://github.com/EPPlusSoftware/EPPlus/wiki).
The work with improving the documentation will continue, feedback is highly appreciated!
没有合适的资源?快使用搜索试试~ 我知道了~
Prism框架下利用WPF 制作的管理系统,有增删改查以及常用Excel读取和批量打印功能
共2000个文件
cache:778个
cs:413个
editorconfig:378个
需积分: 0 8 下载量 27 浏览量
2023-09-03
14:48:08
上传
评论 1
收藏 306.63MB ZIP 举报
温馨提示
通过下载你可以了解到: 1.Prism框架常用方法,IModule的使用,IDialogservice的使用,Navigation的使用,EventAggragator ,Bindablebase的使命令与数据与界面的交互与绑定 2.NPOI读取Excel数据,并更新到SQLite数据库中,Epplus批量打印点表,格式能够维持不变,后期大家可以直接在项目中Copy这个功能 3.SQLSugar 对数据库的部分操作 4.一些委托,Linq等常用的方法大家也可以参考 5.本代码为非盈利性,如果用于商业请与原作者或厂商联系 6.画面有分页功能大家可以直接copy设计思想
资源推荐
资源详情
资源评论
收起资源包目录
Prism框架下利用WPF 制作的管理系统,有增删改查以及常用Excel读取和批量打印功能 (2000个子文件)
IOBaseStyles.baml 24KB
IOBaseStyles.baml 18KB
MainViewDic.baml 16KB
MainViewDic.baml 16KB
MainWindow.baml 9KB
MainWindow.baml 7KB
MainWindow.baml 7KB
TextBoxStyles.baml 5KB
TextBoxStyles.baml 3KB
DialogWindow.baml 1KB
DialogWindow.baml 1KB
DialogWindow.baml 1KB
BSCMGR.Assets.csproj.BuildWithSkipAnalyzers 0B
BSCMGR.Assets.csproj.BuildWithSkipAnalyzers 0B
BSCMGR.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_evsyamek_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_5gjkstqy_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_qsbzcgnz_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_elhdxc2y_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_0rotzbgp_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_ai41yfhf_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_4rgcldom_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_v3ckn4zd_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_floe0ltc_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_wdwcyniv_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_nwh0m2kd_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_ntp0hjtz_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_4kie2j32_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_ehzjk3lc_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_i1424ti1_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_m2in4ri1_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_yui1d4oa_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_rnioy5nw_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_ggkpjwep_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_jgge5k2p_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_0by1dvyx_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_r4ezbkwd_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_xaiwy0nr_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_hjjwtbpu_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_420ix2kj_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_ziuwedzi_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_fnnxdvp2_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_3ljlstok_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_0icbpb2y_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_cj4gquwn_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_gvlhibog_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_txsyxt5p_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_mmmqaiyl_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_nznjodki_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_raqivk1y_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_d4joygu0_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_iqeskxii_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_5if1o1os_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_1abzym1i_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_3bimccwc_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_fofb5cqm_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_vftcoxq5_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_aiemmed1_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_wzaurhnj_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_tdfj12hy_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_pjrl04yw_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_fbyy3w54_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_tzanvude_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_uoojynop_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_opjntnuq_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_hr3vj4rt_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_nmoaohrf_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_e21nnhso_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_zx4e4mcu_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_i5yg3b5j_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_lt3ltbxp_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_txzc4ehg_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_nuckq3ks_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_hpptkf3f_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_adlqc0gj_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_v51pi3ra_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_0dhby2bw_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_r54lzuau_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_qdk00ao3_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_hooqlfyq_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_vwpayvy2_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_pjymoz4e_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_a4nfcxfk_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_dx4hrzfz_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_mpw43itq_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_yvnstws1_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_vchgpeoc_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_o1bsuuyj_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_lthvw5ul_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_slgqifby_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_04qxiuld_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_3dmftb5w_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_ztkf13wl_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_qndy2i2u_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_frklrqwy_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_pb2azh2f_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_qe1n1puw_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_jps22owd_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_f3fwmbgr_wpftmp.csproj.BuildWithSkipAnalyzers 0B
BSCMGR_5jbturtm_wpftmp.csproj.BuildWithSkipAnalyzers 0B
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
^-^齐东墙
- 粉丝: 4
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功