// Nyelvi adatok listázása excelből

        public void langListRead()
        {
            //Szójegyzéket olvassa xls fájlból az adatbázisba.

            List <string> langList1 = new List <string>();
            List <string> langList2 = new List <string>();
            List <string> langList3 = new List <string>();

            excel = new Microsoft.Office.Interop.Excel.Application();
            try
            {
                wb        = (excel.Workbooks.Open(connection()));
                ws        = (Worksheet)wb.ActiveSheet;
                ColLangHu = ws.Columns[1];
                ColLangDe = ws.Columns[2];
                ColLangEn = ws.Columns[3];
                int rowsCount = 0;
                a = new Adatok[rowsCount];
                foreach (Range item in ColLangHu.Cells)
                {
                    if (item.Text != "")
                    {
                        rowsCount++;
                        langList1.Add(item.Text);
                    }
                    else
                    {
                        break;
                    }
                }
                rowsCount = 0;
                foreach (Range item in ColLangDe.Cells)
                {
                    if (item.Text != "")
                    {
                        rowsCount++;
                        langList2.Add(item.Text);
                    }
                    else
                    {
                        break;
                    }
                }
                rowsCount = 0;
                foreach (Range item in ColLangEn.Cells)
                {
                    if (item.Text != "")
                    {
                        rowsCount++;
                        langList3.Add(item.Text);
                    }
                    else
                    {
                        break;
                    }
                }
                db.language(langList1, langList2, langList3);
                wb.Close();
                excel.Quit();
            }
            catch (Exception)
            {
                Environment.Exit(0);
            }
        }