title: Excel.Range.Text value still reading as '######' even after doing an AutoFit() on column
body: <p>I need to read in the formatted values of some excel data (a mixture of dates, numbers and text that I will not know format of prior to runtime) as a series of rows, discarding all blank cells.</p>
  
  <p>I do an autofit on the input columns, so in theory the columns are now wide enough the displayed values of those cells should not be ####, but the autofit seems to have no effect on my output data.</p>
  
  <pre><code>int rowCount = allCells.Rows.Count;
  int colCount = allCells.Columns.Count;
  List&lt;List&lt;string&gt;&gt; nonBlankValues = new List&lt;List&lt;string&gt;&gt;();
  
  
  //to stop values coming out as series of #### due to column width, resize columns
  foreach (Excel.Range col in allCells.Columns)
  {
      col.AutoFit();
  }
  for (int i = 0; i &lt; rowCount; i++)
  {
      List&lt;string&gt; row = new List&lt;string&gt;();
      for (int j = 0; j &lt; colCount; j++)
      {
          Excel.Range cellVal = (Excel.Range)allCells.Cells[i + 1, j + 1]; //Excel ranges are 1 indexed not 0 indexed
          string cellText = cellVal.Text.ToString();
          if (cellText != "")
          {
              row.Add(cellText);
          }
  
      }
      if (row.Count &gt; 0)
      {
          nonBlankValues.Add(row);
      }
  }
  </code></pre>