title: Using OleDB to get Excel Sheet Data, but it's "randomly" not reading cell data of a row
body: <p>I'm currently attempting to extract certain data from thousands of excel files. But this problem is driving me absolutely crazy and I'm in a time-crunch to get this all of these done before a short deadline.</p>
  
  <p>The problem is that it doesn't seem to be retrieving ALL of the data, in particular, these "option" columns as I call them. It's supposed to have -01 all the way to -10 for this particular sheet. These are the only values on the entire sheet that are sometimes not read in. They are sometimes slanted at a 45 degree angel, but it doesn't seem to make a difference if I change their orientation manually before reading the file in.</p>
  
  <p>This is what it's doing:
  <img src="https://i.imgur.com/yIPRbx8.png" alt="Missing certain cells&#39; data..."></p>
  
  <p>This is the excel file in question (not sure if that link will work):<br>
  <a href="https://drive.google.com/file/d/0B7-iwpcLS0GoaVpHYkxPTWdIYUE/view?usp=sharing" rel="nofollow noreferrer">https://drive.google.com/file/d/0B7-iwpcLS0GoaVpHYkxPTWdIYUE/view?usp=sharing</a></p>
  
  <p>Direct download link if that Google spreadsheet fails:<br>
  <a href="http://www.filedropper.com/123456_1" rel="nofollow noreferrer">http://www.filedropper.com/123456_1</a></p>
  
  <p>This is the basic code I'm using ripped out of my application:</p>
  
  <pre><code>Dim xlAppIn As New Excel.Application
  Dim xlWorkbookIn As Excel.Workbook = xlAppIn.Workbooks.Open(sFilename)
  xlAppIn.Visible = False
  
  Dim oleDbConnStr As String = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" &amp; sFilename &amp; ";Extended Properties='Excel 12.0; HDR=No; IMEX=1'"
  Dim oleDbConn As OleDbConnection = New OleDbConnection(oleDbConnStr)
  oleDbConn.Open()
  
  Dim sSheetName As String = xlWorkbookIn.Sheets(1).Name.ToString()
  txtStatus.Text = sSheetName
  
  'Dim oleDbCmd As New OleDbCommand("SELECT * FROM [" &amp; sSheetName &amp; "$B5:AI46]", oleDbConn)
  Dim oleDbCmd As New OleDbCommand("SELECT * FROM [" &amp; sSheetName &amp; "$]", oleDbConn)
  Dim oleDbDa As New OleDbDataAdapter(oleDbCmd)
  
  Dim dt As New DataTable
  oleDbDa.Fill(dt)
  dgvRaw.DataSource = dt
  </code></pre>
  
  <p>What am I doing wrong here?</p>