title: Read Excel range as array of text(string representing what is displayed on the screen for the cell)
body: <p>I am trying to read the entire excel data as array of text(The exact same text as displayed in the cell).</p>
  
  <p>I am using this code to convert the excel content to array</p>
  
  <p><code>Microsoft.Office.Interop.Excel.Range range = excelSheet.get_Range("A1", "P" + excelRowCount);
  object[,] values = (object[,])(range.Text);</code></p>
  
  <p>but I am getting error like cannot convert DBNull to object[,]</p>
  
  <p>The code will work if I replace <code>range.Text</code> with <code>range.Value</code> or <code>range.Value2</code>
  But that won't give the correct data, for example if the data in the cell is 11:00:00 PM the <code>range.Value</code> gives 0.95833333333333337
  here I need to use <code>DateTime.FromOADate()</code> method to convert value 0.95833333333333337 to 11:00:00 PM</p>
  
  <p>But if I go with <code>excelSheet.Cells[rowNo, columnNo].Text</code> I will get the correct text, ie:11:00:00 PM, but that will slowdown the process because there are 40K records in the excel sheet.</p>
  
  <p>Is there any way to get the exact text in to array like <code>object[,] values = (object[,])(range.Value);</code>, why <code>range.Text</code> is not working?</p>