擅长:python、mysql、java
<p>请看这里:<a href="http://openpyxl.readthedocs.org/en/latest/api/openpyxl.worksheet.html?highlight=auto_filter#openpyxl.worksheet.worksheet.Worksheet.auto_filter" rel="noreferrer">http://openpyxl.readthedocs.org/en/latest/api/openpyxl.worksheet.html?highlight=auto_filter#openpyxl.worksheet.worksheet.Worksheet.auto_filter</a></p>
<p>auto_filter命令返回AutoFilter对象,因此在某种意义上它们是相同的。</p>
<p>你需要的是<code>ws.auto_filter.ref = 'C1:C20'</code>
以及要筛选的单元格的范围。</p>