网站建设证有,浙江交通工程建设集团网站,p2p网站开发维护,各大网站推荐前端使用的vue-element-admin框架#xff0c;后端使用ABP框架#xff0c;Excel导出使用的Magicodes.IE.Excel.Abp库。Excel导入和导出操作几乎一样#xff0c;不再介绍。文本主要介绍Excel导出操作和过程中遇到的坑#xff0c;主要是Excel文件导出后无法打开的问题。一.Mag… 前端使用的vue-element-admin框架后端使用ABP框架Excel导出使用的Magicodes.IE.Excel.Abp库。Excel导入和导出操作几乎一样不再介绍。文本主要介绍Excel导出操作和过程中遇到的坑主要是Excel文件导出后无法打开的问题。一.Magicodes.IE库1.Magicodes.IE库介绍 Magicodes.IE是一个导入导出的通用库它支持Dto导入导出、模板导出、花式导出以及动态导出支持Excel、Csv、Word、Pdf和Html。总之基本的和高级的导入和导出操作都是可以满足的。主要特点如下2.Magicodes.IE库的NuGet包Magicodes.IE库相关的NuGet包如下所示(1)Magicodes.IE.Corev2.6.4(2)Magicodes.IE.Excelv2.6.4(3)Magicodes.IE.Excel.NPOIv2.6.4(4)Magicodes.IE.Excel.AspNetCorev2.6.4(5)Magicodes.IE.Pdfv2.6.4(6)Magicodes.IE.Wordv2.6.4(7)Magicodes.IE.Htmlv2.6.4(8)Magicodes.IE.Csvv2.6.4(9)Magicodes.IE.AspNetCorev2.6.4(10)Magicodes.IE.EPPlusv2.6.4(11)Magicodes.IE.Excel.Abpv2.6.4(12)Magicodes.IE.Csv.Abpv2.6.4(13)Magicodes.IE.Html.Abpv2.6.4(14)Magicodes.IE.Pdf.Abpv2.6.4(15)Magicodes.IE.Word.Abpv2.6.43.Magicodes.IE库的教程(1)基础教程之导入学生数据[1](2)基础教程之导出Excel[2](3)基础教程之导出Pdf收据[3](4)在Docker中使用[4](5)动态导出[5](6)多Sheet导入[6](7)Csv导入导出[7](8)Excel图片导入导出[8](9)Excel模板导出之导出教材订购表[9](10)进阶篇之导入导出筛选器[10](11)Magicodes.IE之花式导出[11](12)Magicodes.IE.AspNetCore之一行代码多格式导出[12](13)性能测试[13](14)Excel合并行导入[14](15)Excel模板导出之动态导出[15](16)Magicodes.IE.Excel.AspNetCore之快速导出Excel[16]二.基于ABP的Excel导出操作1.Business.Application.Contracts在该项目中添加Magicodes.IE.Excel.Abp类库。并且BusinessApplicationContractsModule需要依赖MagicodesIEExcelModule模块(1)ExportActivityDto类public class ExportActivityDto : EntityDtoGuid?
{/// summary/// 姓名或微信昵称/// /summary[Required][ExporterHeader(DisplayName 姓名或微信昵称)]public string Name { get; set; }/// summary/// 所在省市区/// /summary[Required][ExporterHeader(DisplayName 所在省市区)]public string Address { get; set; }/// summary/// 手机号/// /summary[Required][ExporterHeader(DisplayName 手机号)]public string Phone { get; set; }/// summary/// 年龄/// /summary[Required][ExporterHeader(DisplayName 年龄)]public string Age { get; set; }/// summary/// 备注/// /summary[ExporterHeader(DisplayName 备注)]public string Remark { get; set; }
}(2)IActivityAppServicepublic interface IActivityAppService : IApplicationService
{// 导出活动列表TaskActionResult ExportActivity();
}2.Business.Application(1)ActivityAppService 通过构造函数注入的方式依赖注入IExcelExporter/// summary
/// 通过Excel导出活动报名信息
/// /summary
/// returns/returns
public async TaskActionResult ExportActivity()
{var query await _repository.GetQueryableAsync();var dto ObjectMapper.MapListActivity, ListExportActivityDto(query.ToList());var result await _excelExporter.ExportAsByteArray(dto);var fs new MemoryStream(result);return new XlsxFileResult(stream: fs, 活动报名信息表.xlsx);
}(2)ActivityAutoMapperProfilepublic class ActivityAutoMapperProfile : Profile
{public ActivityAutoMapperProfile(){CreateMapActivity, ExportActivityDto();}
}3.Business.HttpApi(1)ActivityController[HttpGet]
[Route(export-activity)]
public TaskActionResult ExportActivity()
{return _ActivityAppService.ExportActivity();
}4.Excel导出操作vue代码导出按钮相关的vue代码如下el-button classfilter-item sizemini typesuccess iconel-icon-download clickhandleExport()导出/el-button导出函数的vue代码如下handleExport() {var that this;that.$axios.get(/api/app/activity/export-activity).then(res {this.$notify({title: 成功,message: 导出成功,type: success,duration: 2000});var blob new Blob([res], {type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet});let url window.URL.createObjectURL(blob); //创建下载的链接let a document.createElement(a); //生成一个a标签a.setAttribute(href, url);a.setAttribute(download, that.$activityExcelName);a.style.display none; //将a标签隐藏document.body.appendChild(a); //将a标签添加到body中a.click(); //触发a标签的点击事件window.URL.revokeObjectURL(url); //释放掉blob对象a.remove() //将a标签从body中移除}).catch(() {this.$message({type: info,message: 没有权限导出});});}其中that.$axios.get中的get()代码如下get(url) {return new Promise((resolve, reject) {axios.get(url, { responseType: blob }).then(response {resolve(response.data)}, err {// Message({// message: err.error.message,// type: error,// duration: 5 * 1000// })reject(err)}).catch((error) {reject(error)})})
}说明一定要特别注意加上responseType: blob否则就会报文件格式或者文件扩展名无效的错误。自己尝试了下换成responseType: arraybuffer也是可以的。三.MagicodesIEXXXModule模块源码1.MagicodesIEExcelModule源码public class MagicodesIEExcelModule: AbpModule
{public override void ConfigureServices(ServiceConfigurationContext context){context.Services.AddScopedIExcelExporter, ExcelExporter();context.Services.AddScopedIExcelImporter, ExcelImporter();context.Services.AddScopedIExportFileByTemplate, ExcelExporter();//TODO:处理筛选器}
}2.MagicodesIECsvModule源码public class MagicodesIECsvModule: AbpModule
{public override void ConfigureServices(ServiceConfigurationContext context){context.Services.AddScopedICsvExporter, CsvExporter();context.Services.AddScopedICsvImporter, CsvImporter();}
}3.MagicodesIEHtmlModule源码public class MagicodesIEHtmlModule: AbpModule
{public override void ConfigureServices(ServiceConfigurationContext context){context.Services.AddScopedIHtmlExporter, HtmlExporter();}
}4.MagicodesIEPdfModule源码public class MagicodesIEPdfModule: AbpModule
{public override void ConfigureServices(ServiceConfigurationContext context){context.Services.AddScopedIPdfExporter, PdfExporter();}
}5.MagicodesIEWordModule源码public class MagicodesIEWordModule: AbpModule
{public override void ConfigureServices(ServiceConfigurationContext context){context.Services.AddScopedIWordExporter, WordExporter();}
}参考文献[1]基础教程之导入学生数据https://urlify.cn/neI7Vz[2]基础教程之导出Excelhttps://urlify.cn/yiei6f[3]基础教程之导出Pdf收据https://urlify.cn/7FjuA3[4]在Docker中使用https://github.com/dotnetcore/Magicodes.IE/blob/master/docs/4.在Docker中使用.md[5]动态导出https://github.com/dotnetcore/Magicodes.IE/blob/master/docs/5.动态导出.md[6]多Sheet导入https://github.com/dotnetcore/Magicodes.IE/blob/master/docs/6.多Sheet导入.md[7]Csv导入导出https://github.com/dotnetcore/Magicodes.IE/blob/master/docs/7.Csv导入导出.md[8]Excel图片导入导出https://urlify.cn/Ybyey2[9]Excel模板导出之导出教材订购表https://urlify.cn/vqyQnq[10]进阶篇之导入导出筛选器https://urlify.cn/Nzmmim[11]Magicodes.IE之花式导出https://urlify.cn/QRZRN3[12]Magicodes.IE.AspNetCore之一行代码多格式导出https://github.com/dotnetcore/Magicodes.IE/blob/master/docs/12.Magicodes.IE.AspNetCore之一行代码多格式导出.md[13]性能测试https://github.com/dotnetcore/Magicodes.IE/blob/master/docs/13.性能测试.md[14]Excel合并行导入https://github.com/dotnetcore/Magicodes.IE/blob/master/docs/Excel合并行导入.md[15]Excel模板导出之动态导出https://github.com/dotnetcore/Magicodes.IE/blob/master/docs/Excel模板导出之动态导出.md[16]Magicodes.IE.Excel.AspNetCore之快速导出Excelhttps://github.com/dotnetcore/Magicodes.IE/blob/master/docs/AspNetCore之快速导出Excel.md[17]麦扣官方文档https://docs.xin-lai.com/[18]添加对Abp Vnext模块的封装和支持https://github.com/dotnetcore/Magicodes.IE/issues/318[19]abp框架Excel导出--基于vuehttps://www.cnblogs.com/JerryMouseLi/p/13399027.html[20]abp-vue导入导出excelhttps://cloud.tencent.com/developer/article/1552255[21]使用Magicodes.IE快速导出Excelhttps://www.cnblogs.com/codelove/p/15117226.html[22]dotnetcore/Magicodes.IEhttps://github.com/dotnetcore/Magicodes.IE
