2021.10.13
2021.10.06
2021.10.05
2021.09.02
2021.08.27
2021.08.24
MagicodesIEExcelModule
)MagicodesIECsvModule
)MagicodesIEHtmlModule
)MagicodesIEPdfModule
)MagicodesIEWordModule
)如何使用?
<PackageReference Include="Magicodes.IE.Excel.Abp" Version="2.5.5.2" />
<PackageReference Include="Magicodes.IE.Pdf.Abp" Version="2.5.5.2" />
[DependsOn(
typeof(MagicodesIEExcelModule),
typeof(MagicodesIEPdfModule)
)]
2021.08.07
Magicodes.IE.Excel.AspNetCore
工程,添加XlsxFileResult
的Action Result,支持泛型集合、Bytes数组、Steam直接导出2021.07.23
2021.07.15
2021.07.04
2021.06.29
2021.06.25
2021.06.18
2021.06.05
2021.06.05
2021.06.01
2021.05.26
2021.05.10
2021.04.23
2021.04.18
[ImporterHeader(Name = "序号", Format ="@")]
**YOffset**:垂直偏移(可进行移动图片)
**XOffset**:水平偏移(可进行移动图片)
[ExcelImporter(SheetIndex = 2)]
2021.04.13
2021.04.06
2021.04.03
2021.03.30
2021.03.12
2021.03.08
2021.03.05
2021.02.23
2021.02.20
2021.01.31
2021.01.29
2021.01.09
2021.01.02
2020.12.21
2020.12.03
2020.11.26
2020.11.25
2020.11.20 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)
2020.10.29
2020.10.20
2020.10.01
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
{
AppDependencyResolver.Init(app.ApplicationServices);
//all other code
}
2020.09.26
2020.09.24
2020.09.16
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
{
AppDependencyResolver.Init(app.ApplicationServices);
//all other code
}
2020.09.14
2020.08.30
2020.08.22
2020.08.16
2020.08.10
2020.08.04
COM Interop is not supported on this platform.
修复 #1302020.07.14
2020.07.13
2020.07.06
2020.06.22
【Nuget】版本更新到2.3.0-beta1
【Excel导出】添加对Excel模板导出函数的支持
2020.06.16
2020.06.14
【Nuget】版本更新到2.2.5
【Excel导出】增加分栏、分sheet、追加rows导出 #74
[Excel导出】修复‘IsAllowRepeat=true’ #107
[Pdf导出】增加PDF扩展方法,支持通过以参数形式传递特性参数 #104
2020.06.07
导入失败
仅返回错误行功能SeparateByColumn
进行分割追加列 {{Image::ImageUrl?Width=50&Height=120&Alt=404}}
{{Image::ImageUrl?w=50&h=120&Alt=404}}
{{Image::ImageUrl?Alt=404}}
/// <summary>
/// 追加集合到当前导出程序
/// append the collection to context
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dataItems"></param>
/// <returns></returns>
ExcelExporter Append<T>(ICollection<T> dataItems) where T : class;
/// <summary>
/// 导出所有的追加数据
/// export excel after append all collectioins
/// </summary>
/// <param name="fileName"></param>
/// <returns></returns>
Task<ExportFileInfo> ExportAppendData(string fileName);
/// <summary>
/// 导出所有的追加数据
/// export excel after append all collectioins
/// </summary>
/// <param name="fileName"></param>
/// <returns></returns>
Task<byte[]> ExportAppendDataAsByteArray();
var exporter = new ExcelExporter();
var list1 = GenFu.GenFu.ListOf<ExportTestDataWithAttrs>();
var list2 = GenFu.GenFu.ListOf<ExportTestDataWithSplitSheet>(30);
var result = exporter.Append(list1).Append(list2).ExportAppendData(filePath);
/// <summary>
/// 导出Excel
/// </summary>
/// <param name="fileName">文件名称</param>
/// <param name="dataItems">数据</param>
/// <param name="exporterHeaderFilter">表头筛选器</param>
/// <param name="maxRowNumberOnASheet">一个Sheet最大允许的行数,设置了之后将输出多个Sheet</param>
/// <returns>文件</returns>
Task<ExportFileInfo> Export(string fileName, DataTable dataItems, IExporterHeaderFilter exporterHeaderFilter = null, int maxRowNumberOnASheet = 1000000);
/// <summary>
/// 导出Excel
/// </summary>
/// <param name="dataItems">数据</param>
/// <param name="exporterHeaderFilter">表头筛选器</param>
/// <param name="maxRowNumberOnASheet">一个Sheet最大允许的行数,设置了之后将输出多个Sheet</param>
/// <returns>文件二进制数组</returns>
Task<byte[]> ExportAsByteArray(DataTable dataItems, IExporterHeaderFilter exporterHeaderFilter = null, int maxRowNumberOnASheet = 1000000);
扫码关注腾讯云开发者
领取腾讯云代金券
Copyright © 2013 - 2025 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号:粤B2-20090059 深公网安备号 44030502008569
腾讯云计算(北京)有限责任公司 京ICP证150476号 | 京ICP备11018762号 | 京公网安备号11010802020287
Copyright © 2013 - 2025 Tencent Cloud.
All Rights Reserved. 腾讯云 版权所有