如何检查excel导入中的空字段

Question

从Excel导入到应用程序中，然后使用asp.net mvc和wcf保存在数据库中。 它由于空字段而生成错误。我检查我的数据库和我的代码，我看到，我允许在这些领域为空

请参阅我的控制器下面。

控制器

public ActionResult ImportCacExcel(HttpPostedFileBase FileUpload) 
{ 
    List<string> data = new List<string>(); 
    var bodsList = new List<CAC>(); 
    if (FileUpload != null) 
    { 

     HttpPostedFileBase file = Request.Files["FileUpload"]; 
     if (true)//FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") 
     { 
      using (var package = new ExcelPackage(file.InputStream)) 
      { 
       var currentSheet = package.Workbook.Worksheets; 
       // if(currentSheet.Count) 
       var workSheet = currentSheet.First(); 
       var noOfCol = workSheet.Dimension.End.Column; 
       var noOfRow = workSheet.Dimension.End.Row; 
       for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) 
       { 
        var bod = new CAC(); 

        bod.RC_NUMBER = workSheet.Cells[rowIterator, 1].Value.ToString();//.ToString().Trim(); 
        bod.COMPANY_NAME = workSheet.Cells[rowIterator, 2].Value.ToString();//.ToString().Trim(); 
        bod.OWNERSHIP_STRUCTURE = workSheet.Cells[rowIterator, 3].Value.ToString();//.ToString().Trim();  
        bod.ADDRESS_STREET = workSheet.Cells[rowIterator, 4].Value.ToString(); 
        bod.ADDRESS_CITY = workSheet.Cells[rowIterator, 5].Value.ToString(); 
        bod.ADDRESS_STATE = workSheet.Cells[rowIterator, 6].Value.ToString(); 
        bod.ADDRESS_PMB = workSheet.Cells[rowIterator, 7].Value.ToString(); 
        bod.ADDRESS_POBOX = workSheet.Cells[rowIterator, 8].Value.ToString(); 
        bod.ADDRESS_LGA = workSheet.Cells[rowIterator, 9].Value.ToString(); 

        try 
        { 
         bod.DATE_OF_REGISTRATION = Convert.ToDateTime("01/01/" + workSheet.Cells[rowIterator, 4].Value);//.ToString().Trim(); 
        } 
        catch (Exception e) 
        { 
         data.Add("Bad Date format for item at row " + rowIterator); 
        } 

        bod.ACTION_STATUS = 1; 
        bod.CREATED_DATE = DateTime.Now; 
        bodsList.Add(bod); 
       } 
      } 
      foreach (var item in bodsList) 
      { 
       _cacService.AddCac(item); 
      } 

      return RedirectToAction("Index"); 
     } 
     else 
     { 
      data.Add("<ul>"); 
      data.Add("<li>Only Excel file format is allowed</li>"); 
      data.Add("</ul>"); 
      data.ToArray(); 
      return Json(data, JsonRequestBehavior.AllowGet); 
     } 
    } 
    else 
    { 
     data.Add("<ul>"); 
     if (FileUpload == null) data.Add("<li>Please choose Excel file</li>"); 
     data.Add("</ul>"); 
     data.ToArray(); 
     return Json(data, JsonRequestBehavior.AllowGet); 
    } 
} 

请我怎么改变我的控制器代码ckeck如果像

1. RC_NUMBER
2. COMPANY_NAME
3. OWNERSHIP_STRUCTURE

0的字段

为空或空，它应该指示给用户。 但如果字段，如

1. ADDRESS_STREET
2. ADDRESS_CITY
3. ADDRESS_STATE
4. ADDRESS_PMB
5. ADDRESS_POBOX
6. ADDRESS_LGA

是null或空，它应该增加空的excel，并将null保存到数据库。

Answer 1

要应用用户输入验证，不允许空值传递。客户端验证，例如使用JavaScript将是最好的。这可以防止表单被发布。这还必须包括控制器中的服务器端验证，以防止客户端验证失败，从而防止程序错误。

if(String.IsNullOrWhiteSpace(workSheet.Cells[rowIterator, 1].Value.ToString()) 
{ 
    // Do something to prevent form submission. 
} 
else 
{ 

    bod.RC_NUMBER = workSheet.Cells[rowIterator, 1].Value.ToString(); 
} 

对于所有允许为空的值。将它们初始化为null可能会更简单。然后检查值是否为空，如果不是，则将该值分配给CAC属性。

bod.ADDRESS_STREET = null; 
if(!String.IsNullOrWhiteSpace(workSheet.Cells[rowIterator, 1].Value.ToString()) 
{ 
    bod.ADDRESS_STREET = workSheet.Cells[rowIterator, 4].Value.ToString(); 
}