python里利用openpyxl创建Excel文件，修改Excel文件

from openpyxl import load_workbook
from openpyxl import Workbook


# 导入Excel文件
wb_load = load_workbook(r'e:\20000.xlsx')
ws = wb_load['sheet1']

for i in range(20001):
    ws.cell(row=2 + i, column=1).value = "刘"
    ws.cell(row=2 + i, column=2).value = "男"
    ws.cell(row=2 + i, column=3).value = 18818899001 + i
    ws.cell(row=2 + i, column=4).value = 50001 + i
    ws.cell(row=2 + i, column=5).value = "111"
    ws.cell(row=2 + i, column=6).value = "222"

# 保存到文件
wb_load.save(r'e:\20000.xlsx')

########################################################################


wb_create = Workbook()

ws_1 = wb_create.active
ws_1.title = "第一张"       #sheet名称

ws_2 = wb_create.create_sheet("第2张") #sheet名称

ws_1.cell(row=2, column=1).value = "1张的"
ws_2.cell(row=5, column=3).value = "2张的"
wb_create.save(r"e:\wss.xlsx")