title: Pandas and xlrd error while reading excel files
body: <p>I've been working on a Python script that deals with creating Pandas data frames from Excel files. For the past few days, the Pandas method worked perfectly with the usual <code>pd.read_excel()</code> method.</p>
  <p>Today I've been trying to run the same code, but am running into errors. I've tried using the following code on a small test document (just two columns, 5 rows with simple integers):</p>
  <pre><code>import pandas as pd
  
  pd.read_excel(&quot;tstr.xlsx&quot;)
  
  </code></pre>
  <p>I'm getting this error:</p>
  <pre><code>Traceback (most recent call last):
    File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;
    File &quot;C:\Users\micro\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\util\_decorators.py&quot;, line 296, in wrapper
      return func(*args, **kwargs)
    File &quot;C:\Users\micro\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\io\excel\_base.py&quot;, line 304, in read_excel
      io = ExcelFile(io, engine=engine)
    File &quot;C:\Users\micro\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\io\excel\_base.py&quot;, line 867, in __init__
      self._reader = self._engines[engine](self._io)
    File &quot;C:\Users\micro\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\io\excel\_xlrd.py&quot;, line 22, in __init__
      super().__init__(filepath_or_buffer)
    File &quot;C:\Users\micro\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\io\excel\_base.py&quot;, line 353, in __init__
      self.book = self.load_workbook(filepath_or_buffer)
    File &quot;C:\Users\micro\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\io\excel\_xlrd.py&quot;, line 37, in load_workbook
      return open_workbook(filepath_or_buffer)
    File &quot;C:\Users\micro\AppData\Local\Programs\Python\Python39\lib\site-packages\xlrd\__init__.py&quot;, line 130, in open_workbook
      bk = xlsx.open_workbook_2007_xml(
    File &quot;C:\Users\micro\AppData\Local\Programs\Python\Python39\lib\site-packages\xlrd\xlsx.py&quot;, line 812, in open_workbook_2007_xml
      x12book.process_stream(zflo, 'Workbook')
    File &quot;C:\Users\micro\AppData\Local\Programs\Python\Python39\lib\site-packages\xlrd\xlsx.py&quot;, line 266, in process_stream
      for elem in self.tree.iter() if Element_has_iter else self.tree.getiterator():
  AttributeError: 'ElementTree' object has no attribute 'getiterator'
  </code></pre>
  <p>I get the exact same issue when trying to load excel files with <code>xlrd</code> directly. I've tried with several different excel files, and all of my pip installations are up-to-date.</p>
  <p>I haven't made any changes to my system since <code>pd.read_excel</code> was last working perfectly (I did reboot my system, but it didn't involve any updates). I'm using a Windows 10 machine, if that's relevant.</p>
  <p>Has anyone else had this issue? Any advice on how to proceed?</p>