import xlrd
import hashlib
# excl路径
open_excl = xlrd.open_workbook(r'C:\Users\Administrator\Desktop\add_user.csv')
# 确定读取的sheet
data_sheet = open_excl.sheets()[0]
# 获取sheet行数
rowNum = data_sheet.nrows
# 获取sheet列数
colnum = data_sheet.ncols
# md5加密方法
m = hashlib.md5()
account = [''] # 姓名
roleId = [''] # 权限
phone = [''] # 手机号
pwd = [''] # 密码
for i in range(1, rowNum):
for j in range(0, colnum):
# 取姓名
if j == 0:
account.append(data_sheet.cell(i, j).value)
# 取权限
elif j == 1:
roleId.append(int(data_sheet.cell(i, j).value))
# 取手机号
elif j == 2:
phone.append(int(data_sheet.cell(i, j).value))
# 取密码
else:
pswd = data_sheet.cell(i, j).value
b = bytes(pswd, encoding='UTF-8')
# 将密码经过md5加密
m.update(b)
pwd.append(m.hexdigest())
# add_user(account, roleId, phone)
phone = '1538666666'
money = '20000000'
add_money(phone, money, 4)
文档内容格式: