title: How do I read an excel file in c# without missing any columns?
body: <p>I've been using an OleDb connection to read excel files successfully for quite a while now, but I've run across a problem.  I've got someone who is trying to upload an Excel spreadsheet with nothing in the first column and when I try to read the file, it doesn't recognize that column.</p>
  
  <p>I'm currently using the following OleDb connection string:</p>
  
  <p>Provider=Microsoft.Jet.OLEDB.4.0;<br>
  Data Source=c:\test.xls;<br>
  Extended Properties="Excel 8.0;IMEX=1;"</p>
  
  <p>So, if there are 13 columns in the excel file, the OleDbDataReader I get back only has 12 columns/fields. </p>
  
  <p>Any insight would be appreciated.</p>