擅长:python、mysql、java
<p>我认为您首先需要添加自动过滤器,假设您使用的是<a href="https://openpyxl.readthedocs.io/en/stable/filters.html" rel="nofollow noreferrer">OpenPyXl</a>:</p>
<blockquote>
<p>To add a filter you define a range and then add columns and sort conditions</p>
<pre><code>ws.auto_filter.ref = "A1:B15"
ws.auto_filter.add_filter_column(0, ["Kiwi", "Apple", "Mango"])
ws.auto_filter.add_sort_condition("B2:B15") ```
</code></pre>
</blockquote>
<p>当然,您可以省略<code>add_filter</code>和<code>add_sort_conditions</code>,并将其留给用户进行配置。<a href="https://stackoverflow.com/questions/51566349/openpyxl-how-to-add-filters-to-all-columns">You will need to do simply</a>:</p>
<pre><code>worksheet.auto_filter.ref = worksheet.dimensions
</code></pre>