public IActionResult AddExcel(IFormFile file)
{
System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
using (var stream = file.OpenReadStream())
{
var list = new List <StudentInfo>();
using (var reader = ExcelReaderFactory.CreateReader(stream))
{
bool isFirst = true;
while (reader.Read())
{
if (isFirst)
{
isFirst = false;
continue;
}
if (reader.GetValue(0) == null)
{
break;
}
var model = new StudentInfo();
model.INN = reader.GetValue(0).ToString();
model.Surname = reader.GetValue(1).ToString();
model.Name = reader.GetValue(2).ToString();
model.School = reader.GetValue(3).ToString();
model.Grade = reader.GetValue(4).ToString();
list.Add(model);
}
AccountLogic.AddStudentsInfo(list);
}
}
return(Redirect("/Admin"));
}
