擅长:python、mysql、java
<p>谢谢你的意见。我在writer对象中使用pandas和xlsxwriter引擎解决了这个问题:</p>
<pre><code> if auto_filter == True:
for worksheet in writer.sheets.values():
row_count = len(df.index)
column_count = len(df.columns)
worksheet.autofilter(0, 0, row_count-1, column_count-1)
writer.save()
print("Excel-file generated.")
</code></pre>