title: reader.GetDateTime(null)
body: <p>I'm working on an application that will read from a stored procedure and put into the worksheet. My problem is that when I  run into a null it isn't handled in the code. </p>
  
  <pre><code>               while (reader.Read())
                 {
  
                     ws.Cells[i, 1] = reader.GetString(0);
                     ws.Cells[i, 2] = reader.GetString(1);
                     ws.Cells[i, 3] = reader.GetString(2);
                     ws.Cells[i, 4] = reader.GetString(3);
                     ws.Cells[i, 5] = reader.GetString(4);
                     ws.Cells[i, 6] = reader.GetString(5);
                     ws.Cells[i, 7] = reader.GetDecimal(6);
                     ws.Cells[i, 8] = reader.GetDateTime(7);
                     ws.Cells[i, 9] = reader.GetDecimal(8);
                     ws.Cells[i, 10] = reader.GetDecimal(9);
                     ws.Cells[i, 11] = reader.GetDecimal(10);
                     ws.Cells[i, 12] = reader.GetDecimal(11);
                     ws.Cells[i, 13] = reader.GetDateTime(12);
                     ws.Cells[i, 13] = reader.GetDateTime(13);
                     i++;
                 }
                 reader.Close();
  </code></pre>
  
  <p>if someone could explain how to handle this so that we just leave the cell null; thanks!!</p>