擅长:python、mysql、java
<p>您只需将<code>worksheet.auto_filter.ref</code>设置为工作表单元格的全部范围。在</p>
<pre><code>import openpyxl
from openpyxl.utils import get_column_letter
workbook = openpyxl.load_workbook('Data/Test01.xlsx')
worksheet = workbook['Sheet1']
FullRange = "A1:" + get_column_letter(worksheet.max_column) \
+ str(worksheet.max_row)
worksheet.auto_filter.ref = FullRange
workbook.save('Data/Test03.xlsx')
</code></pre>