From 7e5020ec253df1d0d32304ba72cdaa62937bb26b Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Tue, 1 Feb 2022 20:32:29 +0300 Subject: Refactoring, Not fount table formatting etc --- src/PriceListTools/Target.cs | 18 +++++++++++++----- 1 file changed, 13 insertions(+), 5 deletions(-) (limited to 'src/PriceListTools/Target.cs') diff --git a/src/PriceListTools/Target.cs b/src/PriceListTools/Target.cs index a7e87ec..996a092 100644 --- a/src/PriceListTools/Target.cs +++ b/src/PriceListTools/Target.cs @@ -1,21 +1,29 @@ using Microsoft.Office.Interop.Excel; using System; +using System.Linq; namespace RehauSku.PriceListTools { internal class Target : PriceList { + private const string oldSkuHeader = "Прежний материал"; + public Range oldSkuCell { get; private set; } + public Target(Workbook workbook) { Sheet = workbook.ActiveSheet; Name = workbook.FullName; - amountCell = Sheet.Cells.Find(amountHeader); - skuCell = Sheet.Cells.Find(skuHeader); - groupCell = Sheet.Cells.Find(groupHeader); - nameCell = Sheet.Cells.Find(nameHeader); + Range[] cells = new[] + { + amountCell = Sheet.Cells.Find(amountHeader), + skuCell = Sheet.Cells.Find(skuHeader), + groupCell = Sheet.Cells.Find(groupHeader), + nameCell = Sheet.Cells.Find(nameHeader), + oldSkuCell = Sheet.Cells.Find(oldSkuHeader) + }; - if (amountCell == null || skuCell == null || groupCell == null || nameCell == null) + if (cells.Any(x => x == null)) { throw new ArgumentException($"Шаблон { Name } не является прайс-листом"); } -- cgit v1.2.3