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