title: Help with Excel, Python and XLRD
body: <p>Relatively new to programming hence why I've chosen to use python to learn.</p>
  
  <p>At the moment I'm attempting to read a list of Usernames, passwords from an Excel Spreadsheet with XLRD and use them to login to something. Then back out and go to the next line. Log in etc and keep going.</p>
  
  <p>Here is a snippit of the code:</p>
  
  <pre><code>import xlrd
  wb = xlrd.open_workbook('test_spreadsheet.xls')
  
  # Load XLRD Excel Reader
  
  sheetname = wb.sheet_names() #Read for XCL Sheet names
  sh1 = wb.sheet_by_index(0) #Login
  
  def readRows():
          for rownum in range(sh1.nrows):
                  rows = sh1.row_values(rownum)
                  userNm = rows[4]
                  Password = rows[5]
                  supID = rows[6]
                  print userNm, Password, supID
  
  print readRows()
  </code></pre>
  
  <p>I've gotten the variables out and it reads all of them in one shot, here is where my lack of programming skills come in to play. I know I need to iterate through these and do something with them but Im kind of lost on what is the best practice. Any insight would be great.</p>
  
  <p>Thank you again</p>