title: import excel with pandas using python
body: <p>I'm new to Python and a have a problem.
  I'm trying to import an excel file with pandas and I'm using VS Code.</p>
  <pre class="lang-py prettyprint-override"><code>import pandas as pd
  
  data = pd.read_excel(r'D:\Python\user.xlsx')
  print(data)
  </code></pre>
  <p>I already installed <code>xlrd</code>, but however I get this error:</p>
  <pre><code>Traceback (most recent call last):
    File &quot;d:\Python\import-excel.py&quot;, line 24, in &lt;module&gt;
      data = pd.read_excel(r'D:\Python\user.xlsx')
    File &quot;D:\Python\venv\lib\site-packages\pandas\util\_decorators.py&quot;, line 296, in wrapper
      return func(*args, **kwargs)
    File &quot;D:\Python\venv\lib\site-packages\pandas\io\excel\_base.py&quot;, line 304, in read_excel
      io = ExcelFile(io, engine=engine)
    File &quot;D:\Python\venv\lib\site-packages\pandas\io\excel\_base.py&quot;, line 867, in __init__
      self._reader = self._engines[engine](self._io)
    File &quot;D:\Python\venv\lib\site-packages\pandas\io\excel\_xlrd.py&quot;, line 22, in __init__
      super().__init__(filepath_or_buffer)
    File &quot;D:\Python\venv\lib\site-packages\pandas\io\excel\_base.py&quot;, line 353, in __init__
      self.book = self.load_workbook(filepath_or_buffer)
    File &quot;D:\Python\venv\lib\site-packages\pandas\io\excel\_xlrd.py&quot;, line 37, in load_workbook
      return open_workbook(filepath_or_buffer)
    File &quot;D:\Python\venv\lib\site-packages\xlrd\__init__.py&quot;, line 170, in open_workbook
      raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported')
  xlrd.biffh.XLRDError: Excel xlsx file; not supported
  </code></pre>
  <p>Can somebody help me?</p>