title: Python xlrd data extraction
body: <p>I am using python xlrd <a href="http://scienceoss.com/read-excel-files-from-python/" rel="nofollow noreferrer">http://scienceoss.com/read-excel-files-from-python/</a> to read data from an excel sheet</p>
  
  <p>My question is if i read a row with first cell as "Employee name" in the excel sheet</p>
  
  <p>And there is another row named whose first cell is "Employee name"</p>
  
  <p>How can we read the last column starting with the last row which has "Employee name" in the first cell.Ignoring the previous</p>
  
  <pre><code>  wb = xlrd.open_workbook(file,encoding_override="cp1252") 
    wb.sheet_names()
    sh =  wb.sheet_by_index(0)
    num_of_rows = sh.nrows
    num_of_cols = sh.ncols
    valid_xl_format = 0
    invalid_xl_format = 0
  
    if(num_of_rows != 0):
       for i in range(num_of_rows):
          questions_dict = {}
          for j in range(num_of_cols):
                xl_data=sh.cell(i,j).value
                if ((xl_data == "Employee name")):
                    # Regardless of how many "Employee name" found in rows first cell,Read only the last "Employee name"
  </code></pre>