aboutsummaryrefslogtreecommitdiff
path: root/src/AddIn/WorksheetExtensions.cs
diff options
context:
space:
mode:
authorSerghei Cebotari <51533848+schebotar@users.noreply.github.com>2022-02-14 11:09:22 +0300
committerGitHub <noreply@github.com>2022-02-14 11:09:22 +0300
commit031ea7f7ef0c690d93bb7e653e59c7dac6964dbb (patch)
tree34bb5c7808434a8dad116a052274c271b92f560c /src/AddIn/WorksheetExtensions.cs
parent14aa7249fb6ada16416689f013e1f014727bc83a (diff)
parentf190e27948255303c73a6b457ad1c3af1c88dba9 (diff)
Merge pull request #17 from schebotar/dev
Dev
Diffstat (limited to 'src/AddIn/WorksheetExtensions.cs')
-rw-r--r--src/AddIn/WorksheetExtensions.cs14
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);