title: AttributeError: 'ElementTree' object has no attribute 'getiterator' when trying to import excel file
body: <p>This is my code.
  I've just installed jupyterlab and i've added the excel file in there.
  Same error if i change the path to where the file is on my system.
  I can't seem to find anyone who had the same problem when simply importing an excel file as a dataframe.</p>
  <p>The excel file is a 3x26 table with studentnr, course, result columns that have values like 101-105, A-D, 1.0-9.9 respectively. Maybe the problem lies with the excel file?</p>
  <p>Either way i have no idea how to fix this.</p>
  <pre><code>import pandas as pd
  import numpy as np
  df = pd.read_excel('student-results.xlsx')
  </code></pre>
  <p>This is the error I'm getting:</p>
  <pre><code>---------------------------------------------------------------------------
  AttributeError                            Traceback (most recent call last)
  &lt;ipython-input-6-9d38e4d56bbe&gt; in &lt;module&gt;
        1 import pandas as pd
        2 import numpy as np
  ----&gt; 3 df = pd.read_excel('student-results.xlsx')
  
  c:\python\lib\site-packages\pandas\util\_decorators.py in wrapper(*args, **kwargs)
      294                 )
      295                 warnings.warn(msg, FutureWarning, stacklevel=stacklevel)
  --&gt; 296             return func(*args, **kwargs)
      297 
      298         return wrapper
  
  c:\python\lib\site-packages\pandas\io\excel\_base.py in read_excel(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, parse_dates, date_parser, thousands, comment, skipfooter, convert_float, mangle_dupe_cols)
      302 
      303     if not isinstance(io, ExcelFile):
  --&gt; 304         io = ExcelFile(io, engine=engine)
      305     elif engine and engine != io.engine:
      306         raise ValueError(
  
  c:\python\lib\site-packages\pandas\io\excel\_base.py in __init__(self, path_or_buffer, engine)
      865         self._io = stringify_path(path_or_buffer)
      866 
  --&gt; 867         self._reader = self._engines[engine](self._io)
      868 
      869     def __fspath__(self):
  
  c:\python\lib\site-packages\pandas\io\excel\_xlrd.py in __init__(self, filepath_or_buffer)
       20         err_msg = &quot;Install xlrd &gt;= 1.0.0 for Excel support&quot;
       21         import_optional_dependency(&quot;xlrd&quot;, extra=err_msg)
  ---&gt; 22         super().__init__(filepath_or_buffer)
       23 
       24     @property
  
  c:\python\lib\site-packages\pandas\io\excel\_base.py in __init__(self, filepath_or_buffer)
      351             self.book = self.load_workbook(filepath_or_buffer)
      352         elif isinstance(filepath_or_buffer, str):
  --&gt; 353             self.book = self.load_workbook(filepath_or_buffer)
      354         elif isinstance(filepath_or_buffer, bytes):
      355             self.book = self.load_workbook(BytesIO(filepath_or_buffer))
  
  c:\python\lib\site-packages\pandas\io\excel\_xlrd.py in load_workbook(self, filepath_or_buffer)
       35             return open_workbook(file_contents=data)
       36         else:
  ---&gt; 37             return open_workbook(filepath_or_buffer)
       38 
       39     @property
  
  c:\python\lib\site-packages\xlrd\__init__.py in open_workbook(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows)
      128         if 'xl/workbook.xml' in component_names:
      129             from . import xlsx
  --&gt; 130             bk = xlsx.open_workbook_2007_xml(
      131                 zf,
      132                 component_names,
  
  c:\python\lib\site-packages\xlrd\xlsx.py in open_workbook_2007_xml(zf, component_names, logfile, verbosity, use_mmap, formatting_info, on_demand, ragged_rows)
      810     del zflo
      811     zflo = zf.open(component_names['xl/workbook.xml'])
  --&gt; 812     x12book.process_stream(zflo, 'Workbook')
      813     del zflo
      814     props_name = 'docprops/core.xml'
  
  c:\python\lib\site-packages\xlrd\xlsx.py in process_stream(self, stream, heading)
      264         self.tree = ET.parse(stream)
      265         getmethod = self.tag2meth.get
  --&gt; 266         for elem in self.tree.iter() if Element_has_iter else self.tree.getiterator():
      267             if self.verbosity &gt;= 3:
      268                 self.dump_elem(elem)
  
  AttributeError: 'ElementTree' object has no attribute 'getiterator'
  </code></pre>