title: Reading Row Data from a spreadsheet
body: <p>Using the <a href="http://spreadsheetlight.com/" rel="nofollow">tools SpreadSheetLight</a> I cant find how to read the rows of a spreadsheet file. Specificly Sheet 1.</p>
  
  <p>Two problems Im having is</p>
  
  <ol>
  <li>There is no way that I can see to get the Rows</li>
  <li><p>There is no way that I can see to get the Column Index
  Here is my code</p>
  
  <pre><code>public void ParseExcelFile(FileInfo file) 
  {
      using (SLDocument sl = new SLDocument())
      {
          FileStream fs = new FileStream(file.FullName, FileMode.Open);
  
          MemoryStream msFirstPass = new MemoryStream();
          SLDocument sheet1 = new SLDocument(fs, "Sheet1");
  
  
          // There is no way that I can see to get the Rows
          foreach(var row in sheet1.Rows)
          {
              foreach(SLCell c in row)
              {
                  // There is no way that I can see to get the Column Index
                  switch(c.Column )
                  {
                      case 1:
                          //Handle data if cell is Column 1
                          break;
                      case 2:
                          //Handle data if cell is Column 2
                          break;
                      case 3:
                          //Handle data if cell is Column 3
                          break;
                  }
              }
          }
  
  
  
      }
  
  }//func
  </code></pre></li>
  </ol>