您可以使用 openpyxl
：
import pandas as pdfrom openpyxl import load_workbookbook = load_workbook(filename)writer = pd.ExcelWriter(filename, engine='openpyxl') writer.book = bookwriter.sheets = dict((ws.title, ws) for ws in book.worksheets)df.to_excel(writer, "Data")writer.save()
您需要初始化
writer.sheets以便让您
ExcelWriter知道工作表。否则，它将使用您传递的名称创建一个新工作表。
