使用openpyxl操作excel

# coding:utf-8
import openpyxl

workbook = openpyxl.load_workbook('积分记录明细导入模板.xlsx')   # 工作簿
sheet = workbook['Sheet1']                                    # 工作表

# 用户UID和手机号
users =[
    ('901964','19900001964'),
    ('901963','19900001963'),
    ('901962','19900001962'),
    ('901961','19900001961'),
    ('901960','19900001960'),
    ('901959','19900001959'),
    ('901958','19900001958'),
    ('901957','19900001957'),
    ('901956','19900001956'),
    ('901954','19900001954')
    ]


for i in range(1000):
    for row in range(1,len(users)+1):
        print(row + 1 + i*len(users))
        sheet.cell(row=row + 1 + i*len(users), column=1, value="{}".format(row + i*len(users)))
        sheet.cell(row=row + 1 + i*len(users), column=2, value="{}".format(users[row - 1][0]))
        sheet.cell(row=row + 1 + i*len(users), column=3, value="{}".format(users[row - 1][1]))
        sheet.cell(row=row + 1 + i*len(users), column=4, value="DISTRIBUTE")
        sheet.cell(row=row + 1 + i*len(users), column=5, value="CJYYB_029")
        sheet.cell(row=row + 1 + i*len(users), column=6, value="10")
        sheet.cell(row=row + 1 + i*len(users), column=7, value="1-{}".format(i+1))
        sheet.cell(row=row + 1 + i*len(users), column=8, value="2020-10-1 23:59:59")


# 保存
workbook.save(filename = '积分记录明细导入模板.xlsx')
print('OK！')