title: amend multiple data from an excel file into a new one
body: <p>The work is i am taking input from an excel file and it should result in two cases
  Case 1: if record is found pass onto next record
  Case 2: if record is not found print the registration number in an excel file stating result not found.
  This is what i have so far</p>
  <pre><code>workbook = xlrd.open_workbook(&quot;URL of input file&quot;)
  sheet = workbook.sheet_by_name(&quot;sheet name&quot;)
  worksheet = workbook.sheet_by_index(0)
  a = worksheet.cell(1,0).value  
  wb = openpyxl.Workbook()
  sheet = wb.create_sheet(&quot;NIL Records&quot;, 1)
  sheet[&quot;A1&quot;].value = &quot;Registration Number&quot;
  sheet[&quot;B1&quot;].value = &quot;Status&quot;
  sheet[&quot;A2&quot;].value = a
  sheet[&quot;B2&quot;].value = &quot;Registration Number Not Registered&quot;
  wb.save(&quot;path to the saved location file&quot;)
  </code></pre>
  <p>It is reading only the first record and i want to loop it until the list from the input file completes.
  I want to loop the values of A2 and B2 and increment it
  Any suggestions as to how can i work on it.</p>