public void ImportFromExcelFile(string path)
{
var excelRepository = new ExcelRepository();
var data = excelRepository.GetAllDataFrom(path, "ESPECIALIDADES.xls", "Plan1");
var list = new List<Specialty>();
foreach (DataRow row in data.Rows)
{
var specialty = new Specialty();
foreach (DataColumn column in data.Columns)
{
switch (column.Caption)
{
case "Código do Termo":
specialty.CodeTerm = row[column].ToString();
break;
case "Termo":
specialty.Description = row[column].ToString();
break;
}
}
list.Add(specialty);
}
var specialties = new Specialties();
specialties.SaveList(list);
}