title: Input string was not in a correct format while reading date from excel
body: <p>I am trying to upload an excel sheet. Now I am getting an error for the date column. I was able to fix it up to this point base on some suggestions here.  This is the date format on the excel 20/4/2020</p>
  
  <p>But I couldn't figure it out from this point. I kept getting. I was able to get the Value from the excel sheet and stored in <strong>string date</strong></p>
  
  <blockquote>
    <p>Input string was not in a correct format.
    at System.Number.ThrowOverflowOrFormatException(ParsingStatus status,
    TypeCode type)    at System.Double.Parse(String s)</p>
  </blockquote>
  
  <p>Here is my code below</p>
  
  <pre><code>//be on the first column [r,c]
  int row = 2;
  for (int i = 2; i &lt;= noOfRow; i++)   //start from the second row
  {
      if (!string.IsNullOrEmpty(workSheet.Cells[i, 3].Text))
      {
          string date = workSheet.Cells[i, 3].Value.ToString();
  
          try
          {
              double d = double.Parse(date);//Error is coming from here
              DateTime conv = DateTime.FromOADate(d);
  
          }
          catch (Exception ex)
          {}
      }
  }
  
  </code></pre>
  
  <p>I will appreciate if someone can help me out
  Thanks</p>