public async Task ExportTest_导出Excel_正确导出Excel手动观察()
{
string curDir = Environment.CurrentDirectory;
string fileUrl = Path.Combine(curDir, DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
var carDTO = new ExcelCarTemplateDTO()
{
Age = 10,
CarCode = "鄂A123456",
Gender = GenderEnum.男,
IdentityNumber = "test",
Mobile = "test",
Name = "test",
RegisterDate = DateTime.Now
};
var list = new List <ExcelCarTemplateDTO>();
for (int i = 0; i < 10; i++)
{
list.Add(carDTO);
}
var bytes = await _excelExportService.ExportAsync <ExcelCarTemplateDTO>(list);
File.WriteAllBytes(fileUrl, bytes);
}
public void ValidateTest_导入Excel_有效数据转换正确()
{
var row9 = _rows[9];
Assert.True(row9.IsValid);
ExcelCarTemplateDTO dto = row9.FastConvert <ExcelCarTemplateDTO>();
Assert.True(dto.CarCode == "鄂A57MG2" &&
dto.Gender == GenderEnum.男 &&
dto.Gender.GetHashCode() == 10 &&
dto.Name == "龚英韬" &&
dto.RegisterDate == new DateTime(2018, 1, 1) &&
dto.Age == 18);
}
