public async Task Issue7_Import_EmptyLine() { var fileUrl = Path.Combine(CurrentDir, "Resources/Bugs", "issue7.xlsx"); await Assert.ThrowsAsync <OfficeEmptyLineException>(async() => { try { var workbook = await ImportService.ImportAsync <Issue7>(new ImportOptions() { FileUrl = fileUrl, SheetIndex = 1, DataRowIndex = 3, HeaderRowIndex = 2, EnabledEmptyLine = true }); var result = workbook.GetResult <Issue7>(); Output.WriteLine(result.ToJson()); } catch (OfficeEmptyLineException e) { Output.WriteLine(e.ToJson()); throw; } }); }
public async Task Purchase_Import_IncludeTax() { //预计到货日期 日期格式 有问题 var fileUrl2 = Path.Combine(CurrentDir, "Resources/Purchase", "采购订单导入模板_含税单价2.xlsx"); var workbook2 = await ImportService.ImportAsync <ImportPurchaseOrderIncludeTax>(new ImportOptions() { FileUrl = fileUrl2, SheetIndex = 0, DataRowIndex = 1, HeaderRowIndex = 0, EnabledEmptyLine = false, IgnoreEmptyLineAfterData = true, }); var result2 = workbook2.GetResult <ImportPurchaseOrderIncludeTax>(); Output.WriteLine(result2.ToJson()); var fileUrl = Path.Combine(CurrentDir, "Resources/Purchase", "采购订单导入模板_含税单价.xlsx"); var workbook = await ImportService.ImportAsync <ImportPurchaseOrderIncludeTax>(new ImportOptions() { FileUrl = fileUrl, SheetIndex = 0, DataRowIndex = 1, HeaderRowIndex = 0, EnabledEmptyLine = false, IgnoreEmptyLineAfterData = true, }); var result = workbook.GetResult <ImportPurchaseOrderIncludeTax>(); Output.WriteLine(result.ToJson()); }
public async Task Issue3_ExceptionConvertError() { var fileUrl = Path.Combine(CurrentDir, "Resources/Bugs", "issue3.xlsx"); var workbook = await ImportService.ImportAsync <Issue3>(new ImportOptions() { FileUrl = fileUrl, SheetIndex = 0, DataRowIndex = 3, HeaderRowIndex = 2, }); Assert.Throws <OfficeDataConvertException>(() => { try { var result = workbook.GetResult <Issue3>(); } catch (OfficeDataConvertException e) { Assert.Equal(5, e.RowIndex); Assert.Equal(2, e.ColumnIndex); Assert.Equal("调拨数量", e.Name); Output.WriteLine(e.ToJson()); throw; } }); }
public async Task Issue9_Import_Trim() { var fileUrl = Path.Combine(CurrentDir, "Resources/Bugs", "issue9.xlsx"); var workbook = await ImportService.ImportAsync <Issue9>(new ImportOptions() { FileUrl = fileUrl, SheetIndex = 0, DataRowIndex = 1, HeaderRowIndex = 0, }); var result = workbook.GetResult <Issue9>(); Output.WriteLine(result.ToJson()); }
public async Task Issue7_Import_EmptyLine_Skip() { var fileUrl = Path.Combine(CurrentDir, "Resources/Bugs", "issue7.xlsx"); var workbook = await ImportService.ImportAsync <Issue7>(new ImportOptions() { FileUrl = fileUrl, SheetIndex = 1, DataRowIndex = 3, HeaderRowIndex = 2, EnabledEmptyLine = false }); var result = workbook.GetResult <Issue7>(); Output.WriteLine(result.ToJson()); }
public async Task Issue2_InitCelSoMuch() { var fileUrl = Path.Combine(CurrentDir, "Resources/Bugs", "issue2.xlsx"); await Assert.ThrowsAsync <OfficeException>(async() => { var workbook = await ImportService.ImportAsync <Issue2>(new ImportOptions() { FileUrl = fileUrl, SheetIndex = 0, DataRowIndex = 3, HeaderRowIndex = 2, }); var result = workbook.GetResult <Issue2>(); Output.WriteLine(result.ToJson()); }); }
public async Task Issue5_ValidateFail_ReturnRealLocation_With_HeaderRowIndex() { var fileUrl = Path.Combine(CurrentDir, "Resources/Bugs", "issue5.xlsx"); var workbook = await ImportService.ImportAsync <Issue5>(new ImportOptions { FileUrl = fileUrl, SheetIndex = 0, DataRowIndex = 1, HeaderRowIndex = 0, }); var validateResult = workbook.Validate().ToList(); Assert.True(validateResult.Any()); Assert.Equal(4, validateResult[0].RowIndex); Output.WriteLine(validateResult.ToJson()); }
public async Task Issue8_Import_DateTimeParser() { var fileUrl = Path.Combine(CurrentDir, "Resources/Bugs", "issue8.xlsx"); var workbook = await ImportService.ImportAsync <Issue8>(new ImportOptions() { FileUrl = fileUrl, SheetIndex = 0, DataRowIndex = 1, HeaderRowIndex = 0, }); var result = workbook.GetResult <Issue8>(); result.ForEach(x => { Output.WriteLine(DateTime.Parse(x.CreateTime).ToString()); }); Output.WriteLine(result.ToJson()); }
public async Task Issue1_DecimalConvException() { var fileUrl = Path.Combine(CurrentDir, "Resources/Bugs", "issue1.xlsx"); var workbook = await ImportService.ImportAsync <Issue1>(new ImportOptions() { FileUrl = fileUrl, }); Assert.Throws <OfficeDataConvertException>(() => { try { var result = workbook.GetResult <Issue1>(); } catch (OfficeDataConvertException e) { Assert.Equal(5, e.RowIndex); Assert.Equal(1, e.ColumnIndex); Assert.Equal("值", e.Name); Output.WriteLine(e.ToJson()); throw; } }); }
public async Task Test_That_ImportService_ImportAsync_Throws_NotImplementedException() { Assert.ThrowsExceptionAsync <NotImplementedException>(() => _importService.ImportAsync()); }