格式化xlsxwriter中的pandas数据帧重复工作表名称

import pandas as pd
import xlsxwriter

# 创建一个Excel文件
workbook = xlsxwriter.Workbook('output.xlsx')

# 创建一个工作表
worksheet = workbook.add_worksheet('Sheet1')

# 创建一个示例数据帧
data = {'Name': ['John', 'Amy', 'David', 'Emily'],
        'Age': [25, 28, 22, 30],
        'City': ['New York', 'London', 'Paris', 'Tokyo']}

df = pd.DataFrame(data)

# 将数据写入工作表中
worksheet.write('A1', 'Name')
worksheet.write('B1', 'Age')
worksheet.write('C1', 'City')

# 写入数据帧的内容
for i, row in df.iterrows():
    worksheet.write(i+1, 0, row['Name'])
    worksheet.write(i+1, 1, row['Age'])
    worksheet.write(i+1, 2, row['City'])

# 设置标题行的格式
header_format = workbook.add_format({'bold': True, 'bg_color': 'yellow'})
worksheet.set_row(0, None, header_format)

# 设置数据行的格式
data_format = workbook.add_format({'bg_color': 'white'})
worksheet.set_row(1, None, data_format)

# 关闭Excel文件
workbook.close()