在Python中使用pandas在现有excel中添加多张工作表

import pandas as pd
from openpyxl import load_workbook

excel_file = 'path_to_excel_file.xlsx'
book = load_workbook(excel_file)
writer = pd.ExcelWriter(excel_file, engine='openpyxl')
writer.book = book

data = {'Column1': [1, 2, 3],
        'Column2': ['A', 'B', 'C']}
df = pd.DataFrame(data)

# 将数据写入新的工作表
df.to_excel(writer, sheet_name='Sheet2', index=False)

writer.save()
writer.close()