按照店别新建sheet表

有以下店号
{1,2,3,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,39,41,44,45,46,47,49,50,51,52,53,54,56,57,60,62,63,64,65}
要求按照顺序新建sheet表，每店一个sheet页。

import openpyxl
wb = openpyxl.Workbook()
stores = [1,2,3,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,39,41,44,45,46,47,49,50,51,52,53,54,56,57,60,62,63,64,65]
for i in stores:
    if i < 10:
        wb.create_sheet("st0" + str(i))
    else:
        wb.create_sheet("st" + str(i))

print(wb.sheetnames)
wb.save("creat.xlsx")

生成的表格如下

4D352885-6E87-4b81-9199-8752C1F8C44A.png

===

以下是批量复制模板表

import openpyxl
wb = openpyxl.load_workbook("copy.xlsx")
stores = [1,2,3,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,39,41,44,45,46,47,49,50,51,52,53,54,56,57,60,62,63,64,65]
for i in stores:
    ws = wb.copy_worksheet(wb["模板"])
    if i < 10:
        ws.title = "st0" + str(i)
    else:
        ws.title = "st" + str(i)
wb.remove(wb["模板"])
print(wb.sheetnames)
wb.save("copy-down.xlsx")