title: Python read 1 column of Excel file
body: <p>I'm trying to use <code>openpyxl</code> to read 1 column out of a Excel-file until it hits an empty cell, then it needs to stop. But i don't get it working. This is my code so far:</p>
  
  <pre><code>import openpyxl
  import os
  
  def main():
      filePath = os.getcwd() + "\file.xlsx"
  
      wb = openpyxl.load_workbook(filename=filePath, read_only=True)
      sheet = wb["Sheet1"]
  
  
      for row in range(sheet.max_row):
          if(sheet.cell(row+1,1).value == None):
              break
          print(sheet.cell(row+1,1).value)
  
  
  if __name__ == "__main__":
      main()
  </code></pre>
  
  <p>But this results in the following error:</p>
  
  <blockquote>
    <p>Traceback (most recent call last):<br>
    File "someProgram.py", line 27, in  main()
    File "someProgram.py", line 15, in main<br>
    if(sheet.cell(row+1,1).value == None):<br>
    File "C:\Python34\lib\openpyxl\worksheet\worksheet.py", line 349,<br>
    in cell coordinate = coordinate.upper().replace('$', '')<br>
    AttributeError: 'int' object has no attribute 'upper'</p>
  </blockquote>