Magicodes.IE.Excel 2.5.5.1
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/
公众号：麦扣聊技术
交流QQ群：85318032
**2021.08.07**
- 为了简化ASP.NET Core下的Excel导出，对Excel导出进行了进一步的封装
- 添加`Magicodes.IE.Excel.AspNetCore`工程，添加`XlsxFileResult`的Action Result，支持泛型集合、Bytes数组、Steam直接导出
- 修改部分命名和命名空间
**2021.07.23**
- 修复Excel合并行导入在存在空的合并单元格时可能的数据读取错误[#305](https://github.com/dotnetcore/Magicodes.IE/issues/305)
**2021.07.17**
- Magicodes.EPPlus回退到4.6.6，以修复格式错乱的问题
- 修复Excel仅导出错误数据时的Bug[#302](https://github.com/dotnetcore/Magicodes.IE/pull/302)
- 完善多语言[#298](https://github.com/dotnetcore/Magicodes.IE/pull/298)，以及完善单元测试
**2021.07.04**
- 模板导出支持一行多个表格[#296](https://github.com/dotnetcore/Magicodes.IE/issues/296)
**2021.06.29**
- 合并PR[#295](https://github.com/dotnetcore/Magicodes.IE/pull/295),完善模板导出类型定义的问题
**2021.06.25**
- Fix only first [ColumnIndex] is valid exception[#289](https://github.com/dotnetcore/Magicodes.IE/issues/289)
**2021.06.18**
- Update ImportTestColumnIndex_Test
- Magicodes.EPPlus was upgraded to 4.6.7[#285](https://github.com/dotnetcore/Magicodes.IE/issues/285)
**2021.06.05**
- Fix ImporterHeader->ColumnIndex
- Utilize RecyclableMemoryStream instead of "new MemoryStream" all over
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.5.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.6)
- 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.6)
- DynamicExpresso.Core (>= 2.3.3)
- Magicodes.IE.Core (>= 2.5.5.1)
.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.5.1)
- Magicodes.EPPlus (>= 4.6.6)
| 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 |