Watch only current sheets in files

1 files changed, 21 insertions, 11 deletions

diff --git a/src/PriceListTools/PriceList.cs b/src/PriceListTools/PriceList.cs
index bc11a17..b8bd7b7 100644
--- a/src/PriceListTools/PriceList.cs
+++ b/src/PriceListTools/PriceList.cs
@@ -1,4 +1,5 @@
 using Microsoft.Office.Interop.Excel;
+using System;
 using System.Collections.Generic;
 using System.IO;
 using System.Linq;
@@ -8,25 +9,34 @@ namespace RehauSku.PriceListTools
     internal class PriceList
     {
         public readonly string Name;
-        public readonly PriceListSheet OfferSheet;
-        public List<PriceListSheet> Sheets { get; private set; }
+        //public readonly PriceListSheet OfferSheet;
+        public PriceListSheet Sheet { get; private set; }
 
-        private const string offerSheetHeader = "КП";
+        
+        //private const string offerSheetHeader = "КП";
 
         public PriceList(Workbook workbook)
         {
             Name = workbook.Name;
-            Sheets = new List<PriceListSheet>();
+            Sheet = new PriceListSheet(workbook.ActiveSheet);
 
-            foreach (Worksheet worksheet in workbook.Sheets)
-            {
-                PriceListSheet priceListSheet = new PriceListSheet(worksheet);
+            //foreach (Worksheet worksheet in workbook.Sheets)
+            //{
+            //    try
+            //    {
+            //        PriceListSheet priceListSheet = new PriceListSheet(worksheet);
+            //        //priceListSheet.FillSkuAmount();
+            //        Sheets.Add(priceListSheet);
+            //    }
+            //    catch (Exception ex)
+            //    {
+            //        throw ex;
+            //    }
+            //}
 
-                if (priceListSheet.FillSkuAmount())
-                    Sheets.Add(priceListSheet);
-            }
 
-            OfferSheet = Sheets.Where(s => s.Name == offerSheetHeader).FirstOrDefault();
+
+            //OfferSheet = Sheet.Where(s => s.Name == offerSheetHeader).FirstOrDefault();
         }
 
         public static string CreateNewFile()