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