public async Task GenerateStudentImportTemplate_Test()
{
var filePath = Path.Combine(Directory.GetCurrentDirectory(),
nameof(GenerateStudentImportTemplate_Test) + ".xlsx");
if (File.Exists(filePath))
{
File.Delete(filePath);
}
var result = await Importer.GenerateTemplate <GenerateStudentImportTemplateDto>(filePath);
result.ShouldNotBeNull();
File.Exists(filePath).ShouldBeTrue();
using (var pck = new ExcelPackage(new FileInfo(filePath)))
{
pck.Workbook.Worksheets.Count.ShouldBe(3);
var sheet = pck.Workbook.Worksheets.First();
var dataValidataions = sheet.DataValidations.FirstOrDefault()
as OfficeOpenXml.DataValidation.ExcelDataValidationList;
dataValidataions.Formula.ExcelFormula.ShouldBe("hidden_Gender!$A$1:$A$2");
}
//TODO:读取Excel检查表头和格式
}
public async Task GenerateStudentImportTemplate_Test()
{
var filePath = Path.Combine(Directory.GetCurrentDirectory(),
nameof(GenerateStudentImportTemplate_Test) + ".xlsx");
if (File.Exists(filePath))
{
File.Delete(filePath);
}
var result = await Importer.GenerateTemplate <ImportStudentDto>(filePath);
result.ShouldNotBeNull();
File.Exists(filePath).ShouldBeTrue();
//TODO:读取Excel检查表头和格式
}
