diff options
author | Sergey Chebotar <s.chebotar@gmail.com> | 2023-06-20 07:25:44 +0300 |
---|---|---|
committer | Sergey Chebotar <s.chebotar@gmail.com> | 2023-06-20 07:25:44 +0300 |
commit | 7b8cab3e9e79a94f3c13b6e9900e670e29c782e0 (patch) | |
tree | 5bdd11b9e8fc22ee762d00b92e5a7930afd75a3d /RhSolutions.Tests | |
parent | 50543ae69763dfe6a3684b951fa84d03bf4ebc4f (diff) |
Extract Excel Write Base
Diffstat (limited to 'RhSolutions.Tests')
-rw-r--r-- | RhSolutions.Tests/CanDoGuess.cs | 4 | ||||
-rw-r--r-- | RhSolutions.Tests/CanWriteProducts.cs | 10 | ||||
-rw-r--r-- | RhSolutions.Tests/RealPricelistTest.cs | 2 |
3 files changed, 8 insertions, 8 deletions
diff --git a/RhSolutions.Tests/CanDoGuess.cs b/RhSolutions.Tests/CanDoGuess.cs index ff13106..a43c92e 100644 --- a/RhSolutions.Tests/CanDoGuess.cs +++ b/RhSolutions.Tests/CanDoGuess.cs @@ -25,7 +25,7 @@ public class CanDoGuess : IDisposable Worksheet sourceSheet = Util.Workbook.Worksheets[1]; RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationGuess.xlsx")); var products = _guessReader.ReadProducts(new[] { sourceSheet }); - var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration); + var _writer = new NewPriceWriter(Util.Application, RhSolutionsAddIn.Configuration); _writer.WriteProducts(products); Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; var targetProducts = _reader.ReadProducts(new[] { targetSheet }); @@ -42,7 +42,7 @@ public class CanDoGuess : IDisposable Worksheet sourceSheet = Util.Workbook.Worksheets[1]; RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationGuessOneRow.xlsx")); var products = _guessReader.ReadProducts(new[] { sourceSheet }); - var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration); + var _writer = new NewPriceWriter(Util.Application, RhSolutionsAddIn.Configuration); _writer.WriteProducts(products); Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; var targetProducts = _reader.ReadProducts(new[] { targetSheet }); diff --git a/RhSolutions.Tests/CanWriteProducts.cs b/RhSolutions.Tests/CanWriteProducts.cs index e6868fc..50ce662 100644 --- a/RhSolutions.Tests/CanWriteProducts.cs +++ b/RhSolutions.Tests/CanWriteProducts.cs @@ -23,7 +23,7 @@ public class CanWriteProducts : IDisposable Worksheet sourceSheet = Util.Workbook.Worksheets[1]; RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecification.xlsx")); var products = _reader.ReadProducts(new[] { sourceSheet }); - var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration); + var _writer = new NewPriceWriter(Util.Application, RhSolutionsAddIn.Configuration); _writer.WriteProducts(products); Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; var targetProducts = _reader.ReadProducts(new[] { targetSheet }); @@ -40,7 +40,7 @@ public class CanWriteProducts : IDisposable Worksheet sourceSheet = Util.Workbook.Worksheets[1]; RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationMultipleProductLines.xlsx")); var products = _reader.ReadProducts(new[] { sourceSheet }); - var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration); + var _writer = new NewPriceWriter(Util.Application, RhSolutionsAddIn.Configuration); _writer.WriteProducts(products); Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; var targetProducts = _reader.ReadProducts(new[] { targetSheet }); @@ -57,7 +57,7 @@ public class CanWriteProducts : IDisposable 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); + var _writer = new NewPriceWriter(Util.Application, RhSolutionsAddIn.Configuration); _writer.WriteProducts(products); Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; @@ -72,7 +72,7 @@ public class CanWriteProducts : IDisposable Worksheet sourceSheet = Util.Workbook.Worksheets[1]; RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationReplaced.xlsx")); var products = _reader.ReadProducts(new[] { sourceSheet }); - var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration); + var _writer = new NewPriceWriter(Util.Application, RhSolutionsAddIn.Configuration); _writer.WriteProducts(products); Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; var targetProducts = _reader.ReadProducts(new[] { targetSheet }); @@ -94,7 +94,7 @@ public class CanWriteProducts : IDisposable Worksheet sourceSheet = Util.Workbook.Worksheets[1]; RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationNewVariant.xlsx")); var products = _reader.ReadProducts(new[] { sourceSheet }); - var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration); + var _writer = new NewPriceWriter(Util.Application, RhSolutionsAddIn.Configuration); _writer.WriteProducts(products); Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; var targetProducts = _reader.ReadProducts(new[] { targetSheet }); diff --git a/RhSolutions.Tests/RealPricelistTest.cs b/RhSolutions.Tests/RealPricelistTest.cs index ba8cb68..9ff3a25 100644 --- a/RhSolutions.Tests/RealPricelistTest.cs +++ b/RhSolutions.Tests/RealPricelistTest.cs @@ -23,7 +23,7 @@ public class RealPricelistTest : IDisposable 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); + var _writer = new NewPriceWriter(Util.Application, RhSolutionsAddIn.Configuration); _writer.WriteProducts(products); Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; targetSheet.Range["A1"].Formula = "=SUM(H:H)"; |