title: How can I do this "select * from [sheet1$] where column is L" in Excel using OLEDB for C#?
body: <p>I had asked about this <a href="https://stackoverflow.com/questions/4488403/how-to-iterate-through-a-column-in-an-excel-application-through-c-console">question</a> before but since the requirements changed, I am going to seek for answers again.</p>
  
  <p>I am trying to get all of the contents within the L column of Excel or anything under the DocumentNo heading, which by the way is placed 7 cells below the first row. So the DocumentNo data is at L:7. It is followed by a blank cell, then cells of document numbers. I want to get all of the document numbers and place it in an array to be used in succeeding functions.</p>
  
  <p>Help on this please.
  Thanks.</p>