diff options
author | Serghei Cebotari <51533848+schebotar@users.noreply.github.com> | 2022-02-14 11:09:22 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2022-02-14 11:09:22 +0300 |
commit | 031ea7f7ef0c690d93bb7e653e59c7dac6964dbb (patch) | |
tree | 34bb5c7808434a8dad116a052274c271b92f560c /src/AddIn/WorksheetExtensions.cs | |
parent | 14aa7249fb6ada16416689f013e1f014727bc83a (diff) | |
parent | f190e27948255303c73a6b457ad1c3af1c88dba9 (diff) |
Merge pull request #17 from schebotar/dev
Dev
Diffstat (limited to 'src/AddIn/WorksheetExtensions.cs')
-rw-r--r-- | src/AddIn/WorksheetExtensions.cs | 14 |
1 files changed, 5 insertions, 9 deletions
diff --git a/src/AddIn/WorksheetExtensions.cs b/src/AddIn/WorksheetExtensions.cs index cffa55c..7880b66 100644 --- a/src/AddIn/WorksheetExtensions.cs +++ b/src/AddIn/WorksheetExtensions.cs @@ -1,15 +1,11 @@ using Microsoft.Office.Interop.Excel; +using RehauSku.PriceListTools; 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; @@ -19,10 +15,10 @@ namespace RehauSku Range[] cells = new[] { - amountCell = worksheet.Cells.Find(amountHeader), - skuCell = worksheet.Cells.Find(skuHeader), - groupCell = worksheet.Cells.Find(groupHeader), - nameCell = worksheet.Cells.Find(nameHeader) + amountCell = worksheet.Cells.Find(PriceListHeaders.Amount), + skuCell = worksheet.Cells.Find(PriceListHeaders.Sku), + groupCell = worksheet.Cells.Find(PriceListHeaders.Group), + nameCell = worksheet.Cells.Find(PriceListHeaders.Name) }; return cells.All(x => x != null); |