Add Excel statusbar message for exported lines count

1 files changed, 6 insertions, 1 deletions

diff --git a/src/PriceListTools/PriceList.cs b/src/PriceListTools/PriceList.cs
index e67d573..35b3f7d 100644
--- a/src/PriceListTools/PriceList.cs
+++ b/src/PriceListTools/PriceList.cs
@@ -40,6 +40,7 @@ namespace RehauSku.PriceListTools
 
             int amountColumn = OfferSheet.amountColumn.Value;
             int skuColumn = OfferSheet.skuColumn.Value;
+            int exportedValues = 0;
 
             foreach (KeyValuePair<string, double> kvp in values)
             {
@@ -51,9 +52,12 @@ namespace RehauSku.PriceListTools
                         "Отсутствует позиция в конечной таблице заказов",
                         System.Windows.Forms.MessageBoxButtons.OK,
                         System.Windows.Forms.MessageBoxIcon.Information);
-                }    
+                }
                 else
+                {
                     ws.Cells[cell.Row, amountColumn].Value = kvp.Value;
+                    exportedValues++;
+                }
             }
 
             AutoFilter filter = ws.AutoFilter;
@@ -61,6 +65,7 @@ namespace RehauSku.PriceListTools
 
             filter.Range.AutoFilter(amountColumn - firstFilterColumn + 1, "<>");
             ws.Range["A1"].Activate();
+            ws.Application.StatusBar = $"Экспортировано {exportedValues} строк из {values.Count}";
         }
 
         public class PriceListSheet