title: How to use Python to read one column from Excel file?
body: <p>I want to read the data in one column in excel, here is my code:</p>
  
  <pre><code>import xlrd
  
  file_location = "location/file_name.xlsx"
  
  workbook = xlrd.open_workbook(file_location)
  
  sheet = workbook.sheet_by_name('sheet')
  
  x = []
  
  for cell in sheet.col[9]:
  
      if isinstance(cell, float):
  
          x.append(cell)
  
  print(x)
  </code></pre>
  
  <p>It is wrong because there is no method in sheet called col[col.num], but I just want to extract the data from column 8 (column H), what can I do?</p>