删除和替换Excel工作表中的Pandas DataFrame

import pandas as pd
from openpyxl import load_workbook

file_path = 'path_to_excel_file.xlsx'
df = pd.read_excel(file_path, sheet_name='Sheet1')
wb = load_workbook(file_path)

sheet_name = 'Sheet1'
if sheet_name in wb.sheetnames:
    del wb[sheet_name]

df.to_excel(writer, sheet_name=sheet_name, index=False)
writer.save()

import pandas as pd
from openpyxl import load_workbook

# 读取Excel文件和加载工作簿
file_path = 'path_to_excel_file.xlsx'
df = pd.read_excel(file_path, sheet_name='Sheet1')
wb = load_workbook(file_path)

# 删除工作表中的DataFrame
sheet_name = 'Sheet1'
if sheet_name in wb.sheetnames:
    del wb[sheet_name]

# 创建新的工作表并将DataFrame写入
with pd.ExcelWriter(file_path, mode='xlsxwriter', engine='openpyxl') as writer:
    writer.book = wb
    df.to_excel(writer, sheet_name=sheet_name, index=False)
    writer.save()