public async Task GenerateTemplate_Test()
{
var filePath = Path.Combine(Directory.GetCurrentDirectory(), nameof(GenerateTemplate_Test) + ".xlsx");
if (File.Exists(filePath))
{
File.Delete(filePath);
}
var result = await Importer.GenerateTemplate <ImportProductDto>(filePath);
result.ShouldNotBeNull();
File.Exists(filePath).ShouldBeTrue();
//TODO:读取Excel检查表头和格式
}
public async Task <FileContentResult> GenerateImportTemplate()
{
var filePath = Path.Combine(Directory.GetCurrentDirectory(), nameof(Model.Entity.DemoMain) + ".xlsx");
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
}
var result = await _importer.GenerateTemplate <Model.Dto.ExcelImportDemo>(filePath);
var fileByte = await System.IO.File.ReadAllBytesAsync(result.FileName);
return(File(fileByte, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "测试导入模板.xlsx"));
}
