/// <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();
}
