public void TestImport() { var sheet1 = new BookSheet <ImportStudent> { UniqueValidationPrompt = "零花钱不可重复", HeaderRowIndex = 0, SheetIndex = 0, ValidateHandler = (list) => { foreach (ImportStudent model in list) { if (model.IsValidated && model.Name == "name0") { model.SetError(nameof(model.Name), "名字不可为0"); } if (model.IsValidated && model.Money < 0.5) { model.SetError(nameof(model.Money), "零花钱不可小于0.5"); } } } }; var sheet2 = new BookSheet <ImportGrade> { HeaderRowIndex = 0, SheetIndex = 1 }; var sheet3 = new BookSheet <ImportSchool> { HeaderRowIndex = 1, SheetIndex = 2, ValidateHandler = (list) => { foreach (var model in list) { if (model.Price > 0.5) { model.SetError(nameof(model.Price), "学费不可大于0.5"); } } } }; var bookmodel = new ImportBook().SetSheets(sheet1, sheet2, sheet3); using var inputStream = new FileStream(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Excels//Export.xlsx"), FileMode.OpenOrCreate, FileAccess.Read); using var outStream = new FileStream("D://Export_Error.xlsx", FileMode.Create, FileAccess.Write); var importResult = _importer.ImportExcel(inputStream, ExtEnum.Xlsx, bookmodel, outStream); var success = importResult.ImportSuccess; var summaryErrorMsg = importResult.GetSummaryErrorMessage(); var notDisplayMsg = importResult.GetNotDisplayErrorMessage(); var sheet1Data = importResult.Sheets[0].GetData <ImportStudent>(); Output.WriteLine($"success:{success}"); Output.WriteLine("summaryErrorMsg------------"); Output.WriteLine(summaryErrorMsg); Output.WriteLine("notDisplayMsg------------"); Output.WriteLine(notDisplayMsg); }
public void TestImport() { var sheet = new BookSheet <ImportBalanceOfPayment> { UniqueValidationPrompt = "年月不可重复", HeaderRowIndex = 0, SheetIndex = 0 }; var bookmodel = new ImportBook().SetSheets(sheet); var inputFilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Excels//Simple.xlsx"); using var inputStream = new FileStream(inputFilePath, FileMode.OpenOrCreate, FileAccess.Read); using var outStream = new FileStream("D://Simple_Error.xlsx", FileMode.Create, FileAccess.Write); var importResult = _importer.ImportExcel(inputStream, inputFilePath.GetExt(), bookmodel, outStream); var success = importResult.ImportSuccess; var summaryErrorMsg = importResult.GetSummaryErrorMessage(); var importData = importResult.Sheets[0].GetData <ImportBalanceOfPayment>(); Output.WriteLine($"success:{success}"); Output.WriteLine(summaryErrorMsg); }