title: Python: Pandas read_excel cannot open .xls file, xlrd not supported
body: <p><strong>Problem:</strong></p>
  <p>I am opening a .xls with pd.read_excel, but I got an error.</p>
  <pre><code>df_cima = pd.read_excel(&quot;docs/Presentaciones.xls&quot;)
  
  xlrd.biffh.XLRDError: Excel xlsx file; not supported
  </code></pre>
  <p>The suffix of this file is .xls but this error tells me that it is .xlsx</p>
  <p>Then I tried to add <code>engine=&quot;openpyxl&quot;</code>, which is usually used for reading the .xlsx when xlrd version is no longer 1.2.0, then it gives me another error</p>
  <pre><code>openpyxl.utils.exceptions.InvalidFileException: openpyxl does not support the old .xls file format, please use xlrd to read this file, or convert it to the more recent .xlsx file format.
  </code></pre>
  <p><strong>MY env:</strong></p>
  <ul>
  <li>pandas version: 1.1.5</li>
  <li>xlrd version: 2.0.1</li>
  <li>openpyxl version: 3.0.6</li>
  </ul>
  <p><strong>I do not want to change my xlrd version back to 1.2.0</strong>, from other answer I see that new version of xlrd support only .xls, but I don't understand why it is not working for my file.</p>
  <p>Thanks in advance.</p>