From cc96e1ebe7255c7278c70cef0f951103e9844487 Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Fri, 4 Feb 2022 17:13:47 +0300
Subject: Implement Enable/Disable tools buttons events

---
 src/AddIn/WorksheetExtensions.cs | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)
 create mode 100644 src/AddIn/WorksheetExtensions.cs

(limited to 'src/AddIn/WorksheetExtensions.cs')

diff --git a/src/AddIn/WorksheetExtensions.cs b/src/AddIn/WorksheetExtensions.cs
new file mode 100644
index 0000000..51ce13a
--- /dev/null
+++ b/src/AddIn/WorksheetExtensions.cs
@@ -0,0 +1,32 @@
+using Microsoft.Office.Interop.Excel;
+using System.Linq;
+
+namespace RehauSku
+{
+    public static class WorksheetExtensions
+    {
+        private static string amountHeader = "Кол-во";
+        private static string skuHeader = "Актуальный материал";
+        private static string groupHeader = "Программа";
+        private static string nameHeader = "Наименование";
+
+        public static bool IsRehauSource(this Worksheet worksheet)
+        {
+            Range amountCell;
+            Range skuCell;
+            Range groupCell;
+            Range nameCell;
+
+            Range[] cells = new[]
+            {
+                amountCell = worksheet.Cells.Find(amountHeader),
+                skuCell = worksheet.Cells.Find(skuHeader),
+                groupCell = worksheet.Cells.Find(groupHeader),
+                nameCell = worksheet.Cells.Find(nameHeader)
+            };
+
+            return cells.All(x => x != null);
+        }
+    }
+}
+
-- 
cgit v1.2.3