title: reading excel data by column using VB.NET
body: <p>I have never read from an excel file in VB.NET before so sorry if anything is off.</p>
  
  <p>I am downloading an .csv file from a vendors ftp service that has 8 columns 
  ( style # - mfr.item # - description - metal type - availability - center weight - total weight - retail value )</p>
  
  <p>I am trying to retrieve all data in the rows bellow style # and retail value
  there are roughly 4,649 rows</p>
  
  <p>I am not sure how to do this.</p>
  
  <p>I load the excel file using the microsoft.office.interop.excel:</p>
  
  <pre><code>Dim eApp As excel.Application
  Dim eBook As excel.Workbook
  Dim eSheet As excel.Worksheet
  Dim eCell As excel.Range
  
  eApp = New excel.Application
  eBook = eApp.Workbooks.Open(localFile)
  eSheet = eBook.Worksheets(1)
  eCell = eSheet.UsedRange
  </code></pre>
  
  <p>Can anyone help me on what I need to do next? I have browsed google for a few hours now and have not gotten anything to work, just return an object name.</p>
  
  <p>Thanks</p>