如何使用python ExcelWriter编辑以前创建的excel工作簿

import pandas as pd
from openpyxl import load_workbook

filename = 'path/to/excel/file.xlsx'
book = load_workbook(filename)

writer = pd.ExcelWriter(filename, engine='openpyxl')

writer.book = book

data = {'列1': [1, 2, 3, 4, 5], '列2': ['A', 'B', 'C', 'D', 'E']}
df = pd.DataFrame(data)
df.to_excel(writer, sheet_name='Sheet1', index=False, startrow=1)

writer.save()
writer.close()

import pandas as pd
from openpyxl import load_workbook

# 加载现有的Excel工作簿
filename = 'path/to/excel/file.xlsx'
book = load_workbook(filename)

# 创建ExcelWriter对象
writer = pd.ExcelWriter(filename, engine='openpyxl')

# 将现有的工作簿添加到ExcelWriter对象中
writer.book = book

# 将数据写入现有的工作表
data = {'列1': [1, 2, 3, 4, 5], '列2': ['A', 'B', 'C', 'D', 'E']}
df = pd.DataFrame(data)
df.to_excel(writer, sheet_name='Sheet1', index=False, startrow=1)

# 保存工作簿并关闭ExcelWriter对象
writer.save()
writer.close()