public ActionResult Create(HttpPostedFileBase file) { if (ModelState.IsValid) { if (file != null && file.ContentLength > 0) { //ExcelDataReader works on binary excel file Stream stream = file.InputStream; //We need to written the Interface. IExcelDataReader reader = null; if (file.FileName.EndsWith(".xls")) { //reads the excel file with .xls extension reader = ExcelReaderFactory.CreateBinaryReader(stream); } else if (file.FileName.EndsWith(".xlsx")) { //reads excel file with .xlsx extension reader = ExcelReaderFactory.CreateOpenXmlReader(stream); } else { //Shows error if uploaded file is not Excel file ModelState.AddModelError("File", "This file format is not supported"); return(View()); } //treats the first row of excel file as Coluymn Names reader.IsFirstRowAsColumnNames = true; //Adding reader data to DataSet() DataSet result = reader.AsDataSet(); reader.Close(); //Sending result data to database var finacialYear = _financialYearAppService.GetActiveFinancialYear(); var station = _stationAppService.GetStation(_userAppService.GetLoggedInUser().StationId);// get logged user station _candidateAppService.UploadCandidates(result.Tables[0], finacialYear, station); //return View(); } } else { ModelState.AddModelError("File", "Please upload your file"); } return(RedirectToAction("Create")); }