Пример #1
0
        private void CreaOtch_Click(object sender, RoutedEventArgs e)
        {
            WINoTC WW = new WINoTC();

            WW.Show();
            this.Close();
        }
Пример #2
0
 public void GetFunc()
 {
     int.TryParse(na.Text, out Start.Na4);
     int.TryParse(ko.Text, out Start.Kon4);
     if (Start.Na4 > Start.Kon4)
     {
         MessageBox.Show("Вы ввели некоректное значение", "Ошибка");
     }
     else
     {
         try
         {
             string         g;
             var            App = new Excel.Application();
             Excel.Workbook xlWB;
             string         L;
             StreamReader   rr = new StreamReader("PutHH.txt");
             L = rr.ReadLine();
             //"E:/.../CreatEXcelQWWordOT/CreatEXcelQWWordOT/bin/Debug/Form.xlsx"
             L    = L.Replace(@"\", "/");
             xlWB = App.Workbooks.Open(L);
             int             InFor      = 0;
             Excel.Worksheet worksheet2 = App.Worksheets["Лист1"];
             for (int i = Start.Na4; i <= Start.Kon4; i++)
             {
                 g = worksheet2.Cells[3][i].Formula;
                 g.Replace(@" ", "");
                 Start.str[InFor]  = g;
                 Start.str1[InFor] = worksheet2.Cells[5][i].Formula;
                 InFor            += 1;
                 Start.KolPov     += 1;
             }
             Start.KolPov -= 1;
             xlWB.Close(false, false, false);
             App.Application.Quit();
             App        = null;
             xlWB       = null;
             worksheet2 = null;
             GC.Collect();
             Func.Viz(Start.str);
             WINoTC ww = new WINoTC();
             ww.Show();
             this.Close();
         }
         catch
         {
             WINoTC ww = new WINoTC();
             ww.Show();
             this.Close();
             MessageBox.Show(" Ошибка, введены не верные данные");
         }
     }
 }