import hashlib
import xlrd
import xlwt
# md5加密函数
def md5(arg):
str_hash = hashlib.md5()
str_hash.update(bytes(arg, encoding="utf-8"))
return str_hash.hexdigest()
# 用xlrd模块读取表格,打开excel表
ExcelFile = xlrd.open_workbook(r"d:\1.xlsx")
sheet = ExcelFile.sheet_by_name("Sheet1")
# 用xlwt模块保存,创建表
writework = xlwt.Workbook()
writesheet = writework.add_sheet("shouji_number", cell_overwrite_ok=True)
# 循环要md5加密的列,
shouji_num = sheet.col_values(4)
i = 0
for line in shouji_num:
str_sj_num = str(line)
writesheet.write(i, 9, md5(str_sj_num)) # 加密指定列的数据
i += 1
# 保存
writework.save("1.xls")