title: Cannot Read .xlsx file
body: <p>I am having trouble reading .xlsx files downloaded from an email inbox. I've tried reading through pandas, xlrd and openpyxl. I am able to open the file in excel, and if I manually save the file as a .csv or an excel workbook it will read the file. </p>
  
  <pre><code>openpyxl.load_workbook(path)
  IndexError: list index out of range
  
  xlrd.open_workbook(path)
  XLRDError: ZIP file contents not a known type of workbook
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/rjkIi.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <pre><code>pd.read_excel(path)
  XLRDError: ZIP file contents not a known type of workbook
  </code></pre>
  
  <p>Full Error:
  pd.read_excel(path)</p>
  
  <pre><code>---------------------------------------------------------------------------
  XLRDError                                 Traceback (most recent call last)
  &lt;ipython-input-7-5424c3c557fd&gt; in &lt;module&gt;
  ----&gt; 1 pd.read_excel(path)
  
  ~\Anaconda3\lib\site-packages\pandas\util\_decorators.py in wrapper(*args, **kwargs)
      176                 else:
      177                     kwargs[new_arg_name] = new_arg_value
  --&gt; 178             return func(*args, **kwargs)
      179         return wrapper
      180     return _deprecate_kwarg
  
  ~\Anaconda3\lib\site-packages\pandas\util\_decorators.py in wrapper(*args, **kwargs)
      176                 else:
      177                     kwargs[new_arg_name] = new_arg_value
  --&gt; 178             return func(*args, **kwargs)
      179         return wrapper
      180     return _deprecate_kwarg
  
  ~\Anaconda3\lib\site-packages\pandas\io\excel.py in read_excel(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, parse_dates, date_parser, thousands, comment, skipfooter, convert_float, **kwds)
      305 
      306     if not isinstance(io, ExcelFile):
  --&gt; 307         io = ExcelFile(io, engine=engine)
      308 
      309     return io.parse(
  
  ~\Anaconda3\lib\site-packages\pandas\io\excel.py in __init__(self, io, **kwds)
      392             self.book = xlrd.open_workbook(file_contents=data)
      393         elif isinstance(self._io, compat.string_types):
  --&gt; 394             self.book = xlrd.open_workbook(self._io)
      395         else:
      396             raise ValueError('Must explicitly set engine if not passing in'
  
  ~\Anaconda3\lib\site-packages\xlrd\__init__.py in open_workbook(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows)
      143         if 'content.xml' in component_names:
      144             raise XLRDError('Openoffice.org ODS file; not supported')
  --&gt; 145         raise XLRDError('ZIP file contents not a known type of workbook')
      146 
      147     from . import book
  
  XLRDError: ZIP file contents not a known type of workbook
  </code></pre>