title: Loading Excel file chunk by chunk with Python instead of loading full file into memory
body: <p>I want to read just 10 lines from Excel files (xlsx) without loading the whole file at once, as it can't be done on one of my machines (low memory).</p>
  
  <p>I tried using </p>
  
  <pre><code>import xlrd
  import pandas as pd
  def open_file(path):
      xl = pd.ExcelFile(path)
      reader = xl.parse(chunksize=1000)
      for chunk in reader:
          print(chunk)
  </code></pre>
  
  <p>It seems like the file is loaded first then divided into parts.</p>
  
  <p>How to read only first lines?</p>