title: openpyxl basic search
body: <p>I am trying to search an excel document and if the name of the mp3 file is matched in the excel document, It prints out the row the instance of the name is found on.</p>
  
  <p>this is what I have:</p>
  
  <pre><code>from mutagen.easyid3 import EasyID3
  from openpyxl import load_workbook
  import glob
  import re
  import os
  for name in glob.glob('*.mp3'):
    audio = EasyID3(name)
    wb = load_workbook('xl.xlsx')
    sh = wb.get_sheet_by_name('Russian')
    for row in sh:
      if row.value == name:
        print row.number
  </code></pre>