title: How to iterate over a Row or Column of an Excel sheet using Python and look for specific value in cells?
body: <p>Below is a code I literally copied from someone. It reads and updates an existing Excel file. What I want is to add another functionality of iterating over each row or column and look for a specific value. Then I want to update that specific cell with a new value. </p>
  
  <pre><code>import xlwt
  import xlrd
  from xlutils.copy import copy
  
  rb = xlrd.open_workbook("imtiaz.xls")
  wb = copy(rb)
  w_sheet = wb.get_sheet(0)
  w_sheet.write(0,1,45)
  
  
  w_sheet.write(1,1,46)
  wb.save("imtiaz.xls")
  </code></pre>