Merge pull request #14 from schebotar/dev

Dev

1 files changed, 13 insertions, 5 deletions

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 } не является прайс-листом");
             }