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