title: Using OPENPYXL to extract data from an EXCEL file
body: <p>I have the following code which prints all items from an excel file. What I am wanting to do is enter a name and then search for this name in the spreadsheet and display the price for the corresponding name in column D. The names are listed in column A. The columns I have in my spreadsheet are(Column A: Player, Column B:Team, Column C: points,  Column D: Cost, Column E: position).</p>
  
  <p>What I am aiming to do is search for a players name and print the price for this player.</p>
  
  <pre><code>from openpyxl import load_workbook
  
  print ("Going to execute the script")
  
  workbook = load_workbook("LeaguePlayers.xlsx", use_iterators = True)
  
  name = print(input("Enter player name: "))
  
  for worksheet in workbook:
      for row in worksheet.iter_rows():
          for cell in row:
              if(cell.value != None):
                  print (cell.value)           
  
  print ("End of script execution")
  </code></pre>