/// <summary> /// 执行 /// </summary> public void Execute() { //级联处理 string exportTemplatePath = Directory.GetCurrentDirectory() + "\\..\\Template\\合同导入模板-导出模板.xls"; //第一步 ExcelGlobalDTO <ContractImportDTO> global = new ExcelGlobalDTO <ContractImportDTO>(1); global.SetDefaultSheet("合同"); global.FilePath = exportTemplatePath; //构建数据 ContractImportDTO model = new ContractImportDTO() { Name = "A", Code = "B" }; global.Sheets.First().SheetEntityList = new List <ContractImportDTO>() { model }; //第一步:导出(渲染Excel) Export <ContractImportDTO> exprotFile = new Export <ContractImportDTO>(); exprotFile.ExecuteByFile(exportTemplatePath, ExcelVersionEnum.V2007, global); //第二部 //exprotFile.ExecuteByData(global); //第三步:导出(构建文件流) exprotFile.ExportMemoryStream(global); }
/// <summary> /// 执行 /// </summary> public void Execute() { //初始化全局Excel ExcelGlobalDTO <ContractImportDTO> excelGlobalDTO = new ExcelGlobalDTO <ContractImportDTO>(); excelGlobalDTO.SetDefaultSheet(); //设置级联:父级对象错误信息 ContractImportDTO contract = new ContractImportDTO(); contract.ColumnErrorMessage.Add(new ColumnErrorMessage() { ColumnName = "A" }); //设置级联:从对象错误信息 ContractProductImportDTO product = new ContractProductImportDTO(); product.ColumnErrorMessage.Add(new ColumnErrorMessage() { ColumnName = "B" }); contract.Products = new List <ContractProductImportDTO>() { product }; //设置实体集合 excelGlobalDTO.Sheet.SheetEntityList = new List <ContractImportDTO>() { contract }; //获取所有错误信息 var errors = excelGlobalDTO.GetColumnErrorMessages(); }