我试图在不覆盖完整数据的情况下更新工作表，但是我的代码改为创建新工作表。

import csv
import openpyxl
import pandas as pd
from openpyxl import load_workbook

df1 = pd.read_csv(r'C:\Users\name\Desktop\Data_Sj.csv')
ddf = df1[
    (df1['Sports'] == 'Football')
         ]
print(ddf)

writer = pd.ExcelWriter(r'C:\Users\name\Desktop\check\Checklist1.xlsx',engine= 'openpyxl')

book = load_workbook(r'C:\Users\name\Desktop\check\Checklist1.xlsx')

writer.book = book
ddf.to_excel(r'C:\Users\name\Desktop\check\Checklist1.xlsx')

writer.save()