python学习：Excel中复制多个sheet并修改其名称

python学习：Excel中复制多个sheet并修改其名称

from openpyxl import load_workbook

workbook = load_workbook(filename="123.xlsx")
print(workbook.sheetnames)  # 打印所有sheet的name
# 指定sheet表复制多份
myName = ['名称1', '名称2', '名称3']
# print(len(myName))
for i in range(len(myName)):
    # sheet_name = "{0}#".format(i)
    target = workbook.copy_worksheet(workbook['Sheet1'])  # 复制指定sheet
    # target.title = 'Sheet1(' + str(i) + ')'  # 修改复制后sheet的name
    target.title = myName[i]  # 修改复制后sheet的name
    print(target.title)