From d4ef078b9db6e54d74effcee77f787bf86dabd4c Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Sun, 21 May 2023 15:13:17 +0300 Subject: Add Not Found Writing Test --- RhSolutions.Tests/CanWriteProducts.cs | 18 ++++++++++++++++++ .../TestWorkbooks/TargetSpecificationNotFound.xlsx | Bin 0 -> 9371 bytes .../TestWorkbooks/TestSpecificationNotFound.xlsx | Bin 0 -> 9177 bytes 3 files changed, 18 insertions(+) create mode 100644 RhSolutions.Tests/TestWorkbooks/TargetSpecificationNotFound.xlsx create mode 100644 RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx (limited to 'RhSolutions.Tests') diff --git a/RhSolutions.Tests/CanWriteProducts.cs b/RhSolutions.Tests/CanWriteProducts.cs index accb639..9280d5f 100644 --- a/RhSolutions.Tests/CanWriteProducts.cs +++ b/RhSolutions.Tests/CanWriteProducts.cs @@ -51,6 +51,24 @@ public class CanWriteProducts : IDisposable Assert.True(Enumerable.SequenceEqual(products.First().Item2, targetProducts.First().Item2)); } + + [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationNotFound.xlsx")] + public void CanWriteNotFound() + { + Worksheet sourceSheet = Util.Workbook.Worksheets[1]; + RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationNotFound.xlsx")); + var products = _reader.ReadProducts(new[] { sourceSheet }); + var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration); + _writer.WriteProducts(products); + Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; + + Assert.Equal("???", targetSheet.Range["B4"].Value2); + Assert.Contains("Молот Тора", targetSheet.Range["C4"].Value2); + Assert.Contains("15555551555", targetSheet.Range["C4"].Value2); + } + + + public void Dispose() { _addIn.AutoClose(); diff --git a/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNotFound.xlsx b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNotFound.xlsx new file mode 100644 index 0000000..e26fe55 Binary files /dev/null and b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNotFound.xlsx differ diff --git a/RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx b/RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx new file mode 100644 index 0000000..de111f3 Binary files /dev/null and b/RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx differ -- cgit v1.2.3