Magicodes.IE.Excel 2.5.1.6
导入导出通用库，支持Dto导入导出、模板导出、花式导出以及动态导出，支持Excel、Csv、Word、Pdf和Html。Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
公众号：麦扣聊技术
交流QQ群：85318032
**2021.01.31**
- 【Nuget】版本更新到2.5.1.6
- 部分重构模板导出
- Excel模板导出语法解析加强 #211
- 修复当表格下面存在变量时，无法渲染的Bug
**2021.01.29**
- 【Nuget】版本更新到2.5.1.5
- 移除模板导出时的控制台日志输出
**2021.01.09**
- 【Nuget】版本更新到2.5.1.4
- 修复Excel导出列头索引与内容排序不一致问题及单测 [#226](https://github.com/dotnetcore/Magicodes.IE/issues/226)
**2021.01.02**
- 【Nuget】版本更新到2.5.1.3
- Add PDF support for paper size
- Add PDF support for margins [#223](https://github.com/dotnetcore/Magicodes.IE/issues/223)
**2020.12.21**
- 【Nuget】版本更新到2.5.1
- 导出支持使用ColumnIndex指定导出顺序，以导出时在某些情况下顺序不一致的问题（Export supports the use of ColumnIndex to specify the export order, so that the order is inconsistent in some cases when exporting） [#179](https://github.com/dotnetcore/Magicodes.IE/issues/179)
**2020.12.03**
- 【Nuget】版本更新到2.5.0
- Excel导出支持HeaderRowIndex [#164](https://github.com/dotnetcore/Magicodes.IE/issues/164)
- 增加Excel枚举导出对DescriptionAttribute的支持 [#168](https://github.com/dotnetcore/Magicodes.IE/issues/168)
- Excel生成导入模板支持内置数据验证[#167](https://github.com/dotnetcore/Magicodes.IE/issues/167)
- 支持数据验证
- 支持MaxLengthAttribute、MinLengthAttribute、StringLengthAttribute、RangeAttribute
- 支持输入提示
To fix The Mapping Values of The total length of a Data Validation list always exceed 255 characters (#196)(https://github.com/dotnetcore/Magicodes.IE/issues/196)
- Excel export List data type errors, and formatting issues.[#191](https://github.com/dotnetcore/Magicodes.IE/issues/191) [#193](https://github.com/dotnetcore/Magicodes.IE/issues/193)
- 导入Excel对Enum类型匹配值映射时，忽略值前后空格
- fix MappingValues The total length of a DataValidation list cannot exceed 255 characters [#196](https://github.com/dotnetcore/Magicodes.IE/issues/196)
- Excel导出List数据类型存在错误，以及格式化问题。 [#191](https://github.com/dotnetcore/Magicodes.IE/issues/191) [#193](https://github.com/dotnetcore/Magicodes.IE/issues/193)
- The ColumnIndex property does not appear to be valid in Excel import [#198](https://github.com/dotnetcore/Magicodes.IE/issues/198)
- TableStyle修改为枚举类型
Showing the top 20 packages that depend on Magicodes.IE.Excel.
| Packages | Downloads |
|---|---|
|
Magicodes.IE.Excel.NPOI
Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
导入导出通用库，支持Dto导入导出、模板导出、花式导出以及动态导出，支持Excel、Csv、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
更新记录：https://github.com/dotnetcore/Magicodes.IE/blob/master/RELEASE.md
公众号：麦扣聊技术
交流QQ群：85318032
**2022.04.17**
- 优化了ColumnIndex在生成模板时的实现，增加了ColumnIndex的单测（见PR[#385](https://github.com/dotnetcore/Magicodes.IE/pull/385)）。
- 添加了NPOI的独立扩展包——Magicodes.IE.Excel.NPOI，以便于后续给用户提供更多的支持。目前仅提供了 SaveToExcelWithXSSFWorkbook 扩展方法。
- 修复RequiredIfAttribute的Bug。
- 修复导出JPG图片在Linux环境下可能引起的无限循环的问题（见PR[#396](https://github.com/dotnetcore/Magicodes.IE/pull/396)）。
- Excel图片导入时，图片列支持为空。
- 更新CsvHelper到最新版本，并修改相关代码。
**2022.03.06**
- 完善筛选器注册机制，在指定了特性ImportHeaderFilter、ExporterHeaderFilter等值后，筛选器将匹配对于的类型，如不指定则作为全局筛选器。
**2022.03.02**
- Excel导入时增加回调函数，方便增加自定义验证
- 优化获取DisplayName的逻辑
- 导出CSV支持ColumnIndex
- 优化Pdf导出逻辑，统一各平台导出代码
|
1 |
.NET Framework 4.6.1
- Magicodes.IE.Core (>= 2.5.1.6)
- runtime.osx.10.10-x64.CoreCompat.System.Drawing (>= 5.8.64)
- System.Linq.Dynamic.Core (>= 1.2.6)
- Microsoft.CSharp (>= 4.7.0)
- Magicodes.EPPlus (>= 4.6.3)
- DynamicExpresso.Core (>= 2.3.3)
.NET Standard 2.1
- runtime.osx.10.10-x64.CoreCompat.System.Drawing (>= 5.8.64)
- System.Linq.Dynamic.Core (>= 1.2.6)
- Microsoft.CSharp (>= 4.7.0)
- Magicodes.EPPlus (>= 4.6.3)
- DynamicExpresso.Core (>= 2.3.3)
- Magicodes.IE.Core (>= 2.5.1.6)
.NET Standard 2.0
- runtime.osx.10.10-x64.CoreCompat.System.Drawing (>= 5.8.64)
- Microsoft.CSharp (>= 4.7.0)
- System.Linq.Dynamic.Core (>= 1.2.6)
- DynamicExpresso.Core (>= 2.3.3)
- Magicodes.IE.Core (>= 2.5.1.6)
- Magicodes.EPPlus (>= 4.6.3)
| Version | Downloads | Last updated |
|---|---|---|
| 2.7.5.2 | 1 | 2025/5/31 |
| 2.7.5.1 | 1 | 2025/6/1 |
| 2.7.4.5 | 1 | 2025/6/1 |
| 2.7.4.4 | 1 | 2025/6/1 |
| 2.7.4.3 | 1 | 2025/6/1 |
| 2.7.4.2 | 1 | 2025/6/1 |
| 2.7.4.1 | 1 | 2025/6/1 |
| 2.7.4 | 1 | 2025/6/1 |
| 2.7.3 | 1 | 2025/6/1 |
| 2.7.2 | 1 | 2025/6/1 |
| 2.7.1 | 1 | 2025/6/1 |
| 2.7.0 | 1 | 2025/6/1 |
| 2.7.0-beta2 | 1 | 2025/6/1 |
| 2.7.0-beta | 1 | 2025/6/1 |
| 2.6.9 | 1 | 2025/6/1 |
| 2.6.8 | 1 | 2025/6/1 |
| 2.6.7 | 1 | 2025/6/2 |
| 2.6.6 | 1 | 2025/6/1 |
| 2.6.5-beta1 | 1 | 2025/6/1 |
| 2.6.4 | 1 | 2025/6/1 |
| 2.6.3 | 2 | 2025/6/1 |
| 2.6.2 | 1 | 2025/6/1 |
| 2.6.1 | 1 | 2025/6/1 |
| 2.6.0 | 1 | 2025/6/1 |
| 2.5.6.3 | 1 | 2025/6/2 |
| 2.5.6.2 | 1 | 2025/6/1 |
| 2.5.6.1 | 1 | 2025/6/1 |
| 2.5.6 | 2 | 2025/5/29 |
| 2.5.5.4 | 1 | 2025/6/1 |
| 2.5.5.3 | 1 | 2025/6/2 |
| 2.5.5.2 | 1 | 2025/6/1 |
| 2.5.5.1 | 1 | 2025/6/1 |
| 2.5.5 | 1 | 2025/6/1 |
| 2.5.4.9 | 1 | 2025/6/1 |
| 2.5.4.8 | 1 | 2025/6/1 |
| 2.5.4.7 | 1 | 2025/6/1 |
| 2.5.4.6 | 1 | 2025/6/1 |
| 2.5.4.5 | 1 | 2025/6/1 |
| 2.5.4.4 | 1 | 2025/6/1 |
| 2.5.4.3 | 1 | 2025/6/1 |
| 2.5.4.2 | 1 | 2025/6/1 |
| 2.5.4.1 | 1 | 2025/6/1 |
| 2.5.4 | 1 | 2025/6/1 |
| 2.5.3.9 | 1 | 2025/6/2 |
| 2.5.3.8 | 1 | 2025/6/1 |
| 2.5.3.7 | 1 | 2025/6/1 |
| 2.5.3.6 | 1 | 2025/6/2 |
| 2.5.3.5 | 1 | 2025/6/2 |
| 2.5.3.4 | 1 | 2025/6/1 |
| 2.5.3.3 | 1 | 2025/6/1 |
| 2.5.3.2 | 1 | 2025/6/1 |
| 2.5.3.1 | 1 | 2025/6/1 |
| 2.5.3 | 1 | 2025/6/1 |
| 2.5.2 | 1 | 2025/6/1 |
| 2.5.1.8 | 1 | 2025/6/1 |
| 2.5.1.7 | 1 | 2025/6/1 |
| 2.5.1.6 | 1 | 2025/6/1 |
| 2.5.1.5 | 1 | 2025/6/1 |
| 2.5.1.4 | 1 | 2025/6/1 |
| 2.5.1.3 | 1 | 2025/6/1 |
| 2.5.1.2 | 1 | 2025/6/1 |
| 2.5.1.1 | 1 | 2025/6/1 |
| 2.5.1 | 1 | 2025/6/1 |
| 2.5.0 | 1 | 2025/6/1 |
| 2.5.0-beta6 | 1 | 2025/6/1 |
| 2.5.0-beta5 | 1 | 2025/6/1 |
| 2.5.0-beta4 | 1 | 2025/6/1 |
| 2.5.0-beta3 | 1 | 2025/6/1 |
| 2.5.0-beta2 | 1 | 2025/6/1 |
| 2.5.0-beta1 | 1 | 2025/6/1 |
| 2.4.0 | 1 | 2025/6/1 |
| 2.4.0-beta4 | 1 | 2025/6/1 |
| 2.4.0-beta3 | 1 | 2025/6/1 |
| 2.4.0-beta2 | 1 | 2025/6/1 |
| 2.4.0-beta1 | 1 | 2025/6/1 |
| 2.3.0 | 1 | 2025/6/1 |
| 2.3.0-beta8 | 1 | 2025/6/2 |
| 2.3.0-beta7 | 1 | 2025/6/1 |
| 2.3.0-beta6 | 1 | 2025/6/1 |
| 2.3.0-beta5 | 1 | 2025/6/1 |
| 2.3.0-beta4 | 1 | 2025/6/1 |
| 2.3.0-beta3 | 1 | 2025/6/1 |
| 2.3.0-beta2 | 1 | 2025/6/1 |
| 2.3.0-beta1 | 1 | 2025/6/1 |
| 2.2.7 | 1 | 2025/6/1 |
| 2.2.6 | 1 | 2025/6/1 |
| 2.2.5 | 1 | 2025/6/1 |
| 2.2.4 | 1 | 2025/6/1 |
| 2.2.3 | 1 | 2025/6/1 |
| 2.2.2 | 1 | 2025/6/1 |
| 2.2.1 | 1 | 2025/6/2 |
| 2.2.0 | 1 | 2025/6/1 |
| 2.2.0-beta9 | 1 | 2025/6/1 |
| 2.2.0-beta8 | 1 | 2025/6/1 |
| 2.2.0-beta7 | 1 | 2025/6/1 |
| 2.2.0-beta6 | 1 | 2025/6/1 |
| 2.2.0-beta5 | 1 | 2025/6/1 |
| 2.2.0-beta4 | 1 | 2025/6/1 |
| 2.2.0-beta3 | 1 | 2025/6/1 |
| 2.2.0-beta2 | 1 | 2025/6/1 |
| 2.2.0-beta1 | 1 | 2025/6/1 |
| 2.1.4 | 1 | 2025/6/1 |
| 2.1.2 | 1 | 2025/6/1 |
| 2.1.0 | 1 | 2025/6/1 |
| 2.0.2 | 1 | 2025/6/1 |
| 2.0.1 | 2 | 2025/6/1 |
| 2.0.0 | 1 | 2025/6/1 |
| 2.0.0-beta4 | 1 | 2025/6/1 |
| 2.0.0-beta2 | 1 | 2025/6/1 |
| 2.0.0-beta1 | 1 | 2025/6/1 |
| 1.4.25 | 1 | 2025/6/1 |
| 1.4.24 | 1 | 2025/6/1 |
| 1.4.23 | 1 | 2025/6/1 |
| 1.4.21 | 1 | 2025/6/1 |
| 1.4.20 | 1 | 2025/6/1 |
| 1.4.19 | 1 | 2025/6/1 |
| 1.4.18 | 1 | 2025/6/1 |
| 1.4.17 | 1 | 2025/6/1 |
| 1.4.16 | 1 | 2025/6/1 |
| 1.4.15 | 1 | 2025/6/1 |
| 1.4.14 | 1 | 2025/6/1 |
| 1.4.13 | 1 | 2025/6/1 |
| 1.4.12 | 1 | 2025/6/1 |
| 1.4.11 | 1 | 2025/6/1 |
| 1.4.10 | 1 | 2025/6/1 |
| 1.4.9-beta | 1 | 2025/6/1 |
| 1.4.8-beta | 1 | 2025/6/1 |
| 1.4.7-beta | 1 | 2025/6/1 |
| 1.4.6-beta | 1 | 2025/6/1 |
| 1.4.5 | 1 | 2025/6/1 |
| 1.4.4 | 1 | 2025/6/1 |
| 1.4.3 | 1 | 2025/6/1 |
| 1.4.2 | 1 | 2025/6/2 |
| 1.4.1 | 1 | 2025/6/1 |
| 1.4.0 | 1 | 2025/6/1 |
| 1.3.9 | 1 | 2025/6/1 |
| 1.3.8 | 1 | 2025/6/1 |
| 1.3.7 | 1 | 2025/6/1 |
| 1.3.6 | 1 | 2025/6/1 |
| 1.3.5 | 2 | 2025/5/29 |
| 1.3.4 | 1 | 2025/6/1 |
| 1.3.3 | 1 | 2025/6/1 |
| 1.3.1 | 1 | 2025/6/1 |
| 1.2.1 | 1 | 2025/6/1 |
| 1.2.0 | 1 | 2025/6/1 |
| 1.1.0 | 1 | 2025/6/1 |
| 1.0.8 | 1 | 2025/6/1 |
| 1.0.7 | 1 | 2025/6/1 |
| 1.0.6 | 1 | 2025/6/1 |
| 1.0.5 | 1 | 2025/6/1 |
| 1.0.4 | 1 | 2025/6/1 |
| 1.0.3 | 1 | 2025/6/1 |
| 1.0.2 | 1 | 2025/6/1 |
| 1.0.0 | 1 | 2025/6/1 |