title: Pandas. How to read Excel file from ZIP archive
body: <p>I have .zip archive with filename.xlsx inside it and I want to parse Excel sheet line by line.</p>
  
  <p>How to proper pass filename into pandas.read_excel in this case?</p>
  
  <p>I tried:</p>
  
  <pre><code>import zipfile
  import pandas
  myzip=zipfile.ZipFile(filename.zip)
  for fname in myzip.namelist():
      with myzip.open(fname) as from_archive:
          with pandas.read_excel(from_archive) as fin:
              for line in fin:
              ....
  </code></pre>
  
  <p>but it doesn't seem to work, and the result was:</p>
  
  <pre><code>AttributeError: __exit__
  </code></pre>