diff options
| author | Sergey Chebotar <s.chebotar@gmail.com> | 2023-05-21 15:47:09 +0300 |
|---|---|---|
| committer | Sergey Chebotar <s.chebotar@gmail.com> | 2023-05-21 15:47:09 +0300 |
| commit | 0fcc6320249a2bacc821c31d2d8fddb90798d14d (patch) | |
| tree | 3f89d8fffc4372d59fcec8bbca9aaeef90d6c394 /RhSolutions.Tests | |
| parent | 58f5c5ba4a9fde68e8b758cf715d8b97e900039b (diff) | |
Add real pricelist test
Diffstat (limited to 'RhSolutions.Tests')
| -rw-r--r-- | RhSolutions.Tests/RealPricelistTest.cs | 41 | ||||
| -rw-r--r-- | RhSolutions.Tests/TestWorkbooks/RealTargetSpecification.xlsx | bin | 0 -> 739068 bytes | |||
| -rw-r--r-- | RhSolutions.Tests/TestWorkbooks/RealTestSpecification.xlsm | bin | 0 -> 1904085 bytes |
3 files changed, 41 insertions, 0 deletions
diff --git a/RhSolutions.Tests/RealPricelistTest.cs b/RhSolutions.Tests/RealPricelistTest.cs new file mode 100644 index 0000000..37a9bc4 --- /dev/null +++ b/RhSolutions.Tests/RealPricelistTest.cs @@ -0,0 +1,41 @@ +using Microsoft.Extensions.DependencyInjection; +using RhSolutions.AddIn; +using System.IO; + +namespace RhSolutions.Tests; + +[ExcelTestSettings(OutOfProcess = true)] +public class RealPricelistTest : IDisposable +{ + private RhSolutionsAddIn _addIn; + private IReader _reader; + + public RealPricelistTest() + { + _addIn = new(); + _addIn.AutoOpen(); + _reader = RhSolutionsAddIn.ServiceProvider.GetRequiredService<IReader>(); + } + + [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\RealTestSpecification.xlsm")] + public void CanWrite() + { + Worksheet sourceSheet = Util.Workbook.Worksheets[1]; + RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\RealTargetSpecification.xlsx")); + var products = _reader.ReadProducts(new[] { sourceSheet }); + var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration); + _writer.WriteProducts(products); + Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; + targetSheet.Range["A1"].Formula = "=SUM(H:H)"; + + Assert.Equal("RealTestSpecification", products.First().Item1); + Assert.Equal("RealTargetSpecification.xlsx", Util.Application.ActiveWorkbook.Name); + Assert.Equal(1188.0, targetSheet.Range["A1"].Value); + } + + public void Dispose() + { + _addIn.AutoClose(); + Util.Application.ActiveWindow.Close(SaveChanges: false); + } +} diff --git a/RhSolutions.Tests/TestWorkbooks/RealTargetSpecification.xlsx b/RhSolutions.Tests/TestWorkbooks/RealTargetSpecification.xlsx Binary files differnew file mode 100644 index 0000000..ed3d370 --- /dev/null +++ b/RhSolutions.Tests/TestWorkbooks/RealTargetSpecification.xlsx diff --git a/RhSolutions.Tests/TestWorkbooks/RealTestSpecification.xlsm b/RhSolutions.Tests/TestWorkbooks/RealTestSpecification.xlsm Binary files differnew file mode 100644 index 0000000..b8fcf4a --- /dev/null +++ b/RhSolutions.Tests/TestWorkbooks/RealTestSpecification.xlsm |