diff options
| -rw-r--r-- | RhSolutions.Tests/CanWriteProducts.cs | 18 | ||||
| -rw-r--r-- | RhSolutions.Tests/TestWorkbooks/TargetSpecificationNotFound.xlsx | bin | 0 -> 9371 bytes | |||
| -rw-r--r-- | RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx | bin | 0 -> 9177 bytes |
3 files changed, 18 insertions, 0 deletions
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 Binary files differnew file mode 100644 index 0000000..e26fe55 --- /dev/null +++ b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNotFound.xlsx diff --git a/RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx b/RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx Binary files differnew file mode 100644 index 0000000..de111f3 --- /dev/null +++ b/RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx |