title: Find row with specified text quickly
body: <p>Okay, So I have a very large excel sheet in which I need to find a row with a specified string of text. The size of this sheet is on the order of 10,000 rows. I am currently doing things like this:</p>
  
  <pre><code>    sheet = workbook.ActiveSheet;
  
    // FIND the tape id in column: __________
          int cellRow = 0;
          int x = 0;
          for (x = 1; x &lt;= 1000000; x++)
          {
              if (sheet.Cells[43][x].text.Contains(tapeID))
              {
                  cellRow = x;
                  break;
              }
          }
  </code></pre>
  
  <p>The problem is that this goes on for quite some time....and therefore too slow for my needs. I tried to do the sheet.find() method but it was returning a whole bunch of cells that were wrong.....can somebody help me implement the sheet.find or tell me about a faster way to do this?</p>
  
  <p>I implemented find like this:</p>
  
  <pre><code>        sheet = workbook.ActiveSheet;
             Microsoft.Office.Interop.Excel.Range currentFind = currentFind = sheet.Cells.Find(tapeID, Type.Missing,
      Microsoft.Office.Interop.Excel.XlFindLookIn.xlValues, Microsoft.Office.Interop.Excel.XlLookAt.xlPart, 
      Microsoft.Office.Interop.Excel.XlSearchOrder.xlByRows, Microsoft.Office.Interop.Excel.XlSearchDirection.xlNext, false,
      Type.Missing, Type.Missing); 
  </code></pre>
  
  <p>But when I look at whats inside with
  string value = currentFind[0][0].Text </p>
  
  <p>I get the wrong cell.....does excel use zero addressing here?...going to investigate</p>