// 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); } }