<p dir="auto">When using <code class="notranslate">read_excel</code> to read excel files, I have to install <code class="notranslate">xlrd.</code><br>
<code class="notranslate">read_excel</code> has parameter <code class="notranslate">engine,</code> but its value only can be <code class="notranslate">None</code> or <code class="notranslate">xlrd.</code><br>
<code class="notranslate">ExcelWrite</code> can use <code class="notranslate">openpyxl</code> as <code class="notranslate">engine.</code></p>
<p dir="auto">Why we cannot use <code class="notranslate">openpyxl</code> to read excel files in <code class="notranslate">pandas</code>? Or whether I can or not?</p>
<p dir="auto">I took a brief look at the existing code for importing files with xlrd but it looks tightly coupled with that library and not particularly straightforward to adapt.</p>
<p dir="auto">I think that the read-only mode of openpyxl would be a good fit for Pandas and would like to work with you to provide the necessary API to go from rows to a dataframe. Data is stored by row so this is the only sensible approach. We will be adding read-support for NumPy types, ie. when passed them, but probably not when reading Excel files.</p>