新创建的工作表不断被删除- Python/Pandas/Openpyxl

import pandas as pd
from openpyxl import load_workbook

# 读取Excel文件
df = pd.read_excel('example.xlsx', sheet_name='Sheet1')

# 处理数据
df['New Column'] = df['Old Column'] * 2

# 写入Excel文件
with pd.ExcelWriter('example.xlsx', engine='openpyxl') as writer:
    df.to_excel(writer, sheet_name='Sheet1', index=False)

# 分块读取数据
chunksize = 1000
for chunk in pd.read_excel('example.xlsx', sheet_name='Sheet1', chunksize=chunksize):
    # 处理数据
    chunk['New Column'] = chunk['Old Column'] * 2
    # 写入Excel文件
    with pd.ExcelWriter('example.xlsx', engine='openpyxl', mode='a') as writer:
        chunk.to_excel(writer, sheet_name='Sheet1', index=False)

pip install --upgrade pandas openpyxl