pandas文档表示，它对
xlsx文件使用
openpyxl。快速浏览一下其中的代码
ExcelWriter可以提示可能会发生以下情况：
import pandasfrom openpyxl import load_workbookbook = load_workbook('Masterfile.xlsx')writer = pandas.ExcelWriter('Masterfile.xlsx', engine='openpyxl') writer.book = bookwriter.sheets = dict((ws.title, ws) for ws in book.worksheets)data_filtered.to_excel(writer, "Main", cols=['Diff1', 'Diff2'])writer.save()
