md5 加密与解密（execel批量MD5加密工具和）
md5 加密与解密（execel批量MD5加密工具和）
选择当前活动的execel单元格
代码如下:
from tkinter.filedialog import *
from tkinter import *
import openpyxl
import hashlib
info ={'path':[]}
#字体样式
_font = ['Hack' 20 'bold']
_font_zi = ['Hack' 15 'bold']
# 每一个sheet固定的列
def get_max_row(sheet):
i=sheet.max_row
real_max_row = 0
while i > 0:
row_dict = {i.value for i in sheet[i]}
if row_dict == {None}:
i = i-1
else:
real_max_row = i
break
return real_max_row
def make_app():
app = Tk()
Label(app text='MD5加密工具' font=_font).pack()
Label(app text='文件名_选择加密的列 点击加密!' font=_font_zi).pack()
Label(app name="f_name" text='暂无文件' font=_font).pack()
#fill=BOTH 左右两边 expand=True 上下两边
Listbox(app name='listbox' bg='#f2f2f2').pack(fill=BOTH expand=True)
Button(app name='open' text='打开excel文件' command=ui_getdata font=_font_zi width=1).pack(fill=BOTH expand=True)
Button(app name='compress_min' text='MD5加密小写' command=md5_min_T font=_font_zi).pack(fill=BOTH expand=True)
Button(app name='compress_max' text='MD5加密大写' command=md5_max_T font=_font_zi).pack(fill=BOTH expand=True)
#初始框大小
app.geometry('400x800')
return app
#ui界面交互
tou_sheet=[]
def ui_getdata():
f_name = askopenfilename()
#赋值--路径添加到数据字典中
info['path']=f_name
if f_name:
app.children['f_name']['text'] = f_name.split("/")[-1]
#得到文件
again_get_cloum(f_name)
def again_get_cloum(f_name):
wookbook = openpyxl.load_workbook(f_name)
book_sheet = wookbook.active
list_box = app.children['listbox']
# 缓存清空数据
list_box.delete(0 END)
tou_sheet.clear()
for yy in range(1 book_sheet.max_column 1):
print(str(book_sheet.cell(1 yy).value))
tou_sheet.append(book_sheet.cell(1 yy).value)
list_box.insert(END book_sheet.cell(1 yy).value)
#加密功能
def md5_min_T():
#重新得到最新的列
# 得到文件
f_name_s = info['path']
if f_name_s:
wookbook = openpyxl.load_workbook(f_name_s)
book_sheet = wookbook.active
listbox = app.children['listbox']
colum = listbox.get(ACTIVE)
cloum_num=tou_sheet.index(colum) 1
book_sheet.insert_cols(cloum_num 1 1)
#循环行
for x in range(2 get_max_row(book_sheet) 1):
if x == 2:
book_sheet.cell(1 cloum_num 1 book_sheet.cell(1 cloum_num).value "_小写_加密成功")
book_sheet.cell(x cloum_num 1 md5_min(book_sheet.cell(x cloum_num).value))
wookbook.save(f_name_s)
# 得到文件
again_get_cloum(info['path'])
def md5_max_T():
#重新得到最新的列
# 得到文件
f_name_s = info['path']
if f_name_s:
wookbook = openpyxl.load_workbook(f_name_s)
book_sheet = wookbook.active
listbox = app.children['listbox']
colum = listbox.get(ACTIVE)
cloum_num=tou_sheet.index(colum) 1
book_sheet.insert_cols(cloum_num 1 1)
#循环行
for x in range(2 book_sheet.max_row 1):
if x == 2:
book_sheet.cell(1 cloum_num 1 book_sheet.cell(1 cloum_num).value "_大写_加密成功")
book_sheet.cell(x cloum_num 1 md5_max(book_sheet.cell(x cloum_num).value))
wookbook.save(f_name_s)
# 得到文件
again_get_cloum(info['path'])
def md5_max(s):
return hashlib.md5(s.encode()).hexdigest().upper()
def md5_min(s):
return hashlib.md5(s.encode()).hexdigest()
#主显示框
if __name__=='__main__':
app = make_app()
app.mainloop()
同理
SM3加密工具代码如下:
from tkinter.filedialog import *
from tkinter import *
import openpyxl
from math import ceil
info ={'path':[]}
#字体样式
_font = ['Hack' 20 'bold']
_font_zi = ['Hack' 15 'bold']
def make_app():
app = Tk()
Label(app text='SM3加密工具' font=_font).pack()
Label(app text='文件名_选择加密的列 点击加密!' font=_font_zi).pack()
Label(app name="f_name" text='暂无文件' font=_font).pack()
#fill=BOTH 左右两边 expand=True 上下两边
Listbox(app name='listbox' bg='#f2f2f2').pack(fill=BOTH expand=True)
Button(app name='open' text='打开excel文件' command=ui_getdata font=_font_zi width=1).pack(fill=BOTH expand=True)
Button(app name='compress_min' text='SM3加密小写' command=sm3_min_T font=_font_zi).pack(fill=BOTH expand=True)
Button(app name='compress_max' text='SM3加密大写' command=sm3_max_T font=_font_zi).pack(fill=BOTH expand=True)
#初始框大小
app.geometry('400x800')
return app
#ui界面交互
tou_sheet=[]
def ui_getdata():
# ui_change('压缩')
f_name = askopenfilename()
#赋值--路径添加到数据字典中
info['path']=f_name
if f_name:
app.children['f_name']['text'] = f_name.split("/")[-1]
#得到文件
again_get_cloum(f_name)
def again_get_cloum(f_name):
wookbook = openpyxl.load_workbook(f_name)
book_sheet = wookbook.active
list_box = app.children['listbox']
# 缓存清空数据
list_box.delete(0 END)
tou_sheet.clear()
for yy in range(1 book_sheet.max_column 1):
print(str(book_sheet.cell(1 yy).value))
tou_sheet.append(book_sheet.cell(1 yy).value)
list_box.insert(END book_sheet.cell(1 yy).value)
#加密功能
def sm3_min_T():
#重新得到最新的列
# 得到文件
f_name_s = info['path']
if f_name_s:
wookbook = openpyxl.load_workbook(f_name_s)
book_sheet = wookbook.active
listbox = app.children['listbox']
colum = listbox.get(ACTIVE)
cloum_num=tou_sheet.index(colum) 1
book_sheet.insert_cols(cloum_num 1 1)
#循环行
for x in range(2 book_sheet.max_row 1):
if x == 2:
book_sheet.cell(1 cloum_num 1 book_sheet.cell(1 cloum_num).value "_小写_加密成功")
book_sheet.cell(x cloum_num 1 sm3_min(book_sheet.cell(x cloum_num).value))
wookbook.save(f_name_s)
# 得到文件
again_get_cloum(info['path'])
def sm3_max_T():
#重新得到最新的列
# 得到文件
f_name_s = info['path']
if f_name_s:
wookbook = openpyxl.load_workbook(f_name_s)
book_sheet = wookbook.active
listbox = app.children['listbox']
colum = listbox.get(ACTIVE)
cloum_num=tou_sheet.index(colum) 1
book_sheet.insert_cols(cloum_num 1 1)
#循环行
for x in range(2 book_sheet.max_row 1):
if x == 2:
book_sheet.cell(1 cloum_num 1 book_sheet.cell(1 cloum_num).value "_大写_加密成功")
book_sheet.cell(x cloum_num 1 sm3_max(book_sheet.cell(x cloum_num).value))
wookbook.save(f_name_s)
# 得到文件
again_get_cloum(info['path'])
IV="7380166f 4914b2b9 172442d7 da8a0600 a96f30bc 163138aa e38dee4d b0fb0e4e"
IV = int(IV.replace(" " "") 16)
a = []
for i in range(0 8):
a.append(0)
a[i] = (IV >> ((7 - i) * 32)) & 0xFFFFFFFF
IV = a
def out_hex(list1):
for i in list1:
print("x" % i)
print("\n")
def rotate_left(a k):
k = k % 32
return ((a << k) & 0xFFFFFFFF) | ((a & 0xFFFFFFFF) >> (32 - k))
T_j = []
for i in range(0 16):
T_j.append(0)
T_j[i] = 0x79cc4519
for i in range(16 64):
T_j.append(0)
T_j[i] = 0x7a879d8a
def FF_j(X Y Z j):
if 0 <= j and j < 16:
ret = X ^ Y ^ Z
elif 16 <= j and j < 64:
ret = (X & Y) | (X & Z) | (Y & Z)
return ret
def GG_j(X Y Z j):
if 0 <= j and j < 16:
ret = X ^ Y ^ Z
elif 16 <= j and j < 64:
#ret = (X | Y) & ((2 ** 32 - 1 - X) | Z)
ret = (X & Y) | ((~ X) & Z)
return ret
def P_0(X):
return X ^ (rotate_left(X 9)) ^ (rotate_left(X 17))
def P_1(X):
return X ^ (rotate_left(X 15)) ^ (rotate_left(X 23))
def CF(V_i B_i):
W = []
for i in range(16):
weight = 0x1000000
data = 0
for k in range(i*4 (i 1)*4):
data = data B_i[k]*weight
weight = int(weight/0x100)
W.append(data)
for j in range(16 68):
W.append(0)
W[j] = P_1(W[j-16] ^ W[j-9] ^ (rotate_left(W[j-3] 15))) ^ (rotate_left(W[j-13] 7)) ^ W[j-6]
str1 = "x" % W[j]
W_1 = []
for j in range(0 64):
W_1.append(0)
W_1[j] = W[j] ^ W[j 4]
str1 = "x" % W_1[j]
A B C D E F G H = V_i
"""
print "00"
out_hex([A B C D E F G H])
"""
for j in range(0 64):
SS1 = rotate_left(((rotate_left(A 12)) E (rotate_left(T_j[j] j))) & 0xFFFFFFFF 7)
SS2 = SS1 ^ (rotate_left(A 12))
TT1 = (FF_j(A B C j) D SS2 W_1[j]) & 0xFFFFFFFF
TT2 = (GG_j(E F G j) H SS1 W[j]) & 0xFFFFFFFF
D = C
C = rotate_left(B 9)
B = A
A = TT1
H = G
G = rotate_left(F 19)
F = E
E = P_0(TT2)
A = A & 0xFFFFFFFF
B = B & 0xFFFFFFFF
C = C & 0xFFFFFFFF
D = D & 0xFFFFFFFF
E = E & 0xFFFFFFFF
F = F & 0xFFFFFFFF
G = G & 0xFFFFFFFF
H = H & 0xFFFFFFFF
"""
str1 = "d" % j
if str1[0] == "0":
str1 = ' ' str1[1:]
print str1
out_hex([A B C D E F G H])
"""
V_i_1 = []
V_i_1.append(A ^ V_i[0])
V_i_1.append(B ^ V_i[1])
V_i_1.append(C ^ V_i[2])
V_i_1.append(D ^ V_i[3])
V_i_1.append(E ^ V_i[4])
V_i_1.append(F ^ V_i[5])
V_i_1.append(G ^ V_i[6])
V_i_1.append(H ^ V_i[7])
return V_i_1
def hash_msg(msg):
# print(msg)
len1 = len(msg)
reserve1 = len1 % 64
msg.append(0x80)
reserve1 = reserve1 1
# 56-64 add 64 byte
range_end = 56
if reserve1 > range_end:
range_end = range_end 64
for i in range(reserve1 range_end):
msg.append(0x00)
bit_length = (len1) * 8
bit_length_str = [bit_length % 0x100]
for i in range(7):
bit_length = int(bit_length / 0x100)
bit_length_str.append(bit_length % 0x100)
for i in range(8):
msg.append(bit_length_str[7-i])
# print(msg)
group_count = round(len(msg) / 64)
B = []
for i in range(0 group_count):
B.append(msg[i*64:(i 1)*64])
V = []
V.append(IV)
for i in range(0 group_count):
V.append(CF(V[i] B[i]))
y = V[i 1]
result = ""
for i in y:
result = '%sx' % (result i)
return result
def str2byte(msg): # 字符串转换成byte数组
ml = len(msg)
msg_byte = []
msg_bytearray = msg.encode('utf-8')
for i in range(ml):
msg_byte.append(msg_bytearray[i])
return msg_byte
def byte2str(msg): # byte数组转字符串
ml = len(msg)
str1 = b""
for i in range(ml):
str1 = b'%c' % msg[i]
return str1.decode('utf-8')
def hex2byte(msg): # 16进制字符串转换成byte数组
ml = len(msg)
if ml % 2 != 0:
msg = '0' msg
ml = int(len(msg)/2)
msg_byte = []
for i in range(ml):
msg_byte.append(int(msg[i*2:i*2 2] 16))
return msg_byte
def byte2hex(msg): # byte数组转换成16进制字符串
ml = len(msg)
hexstr = ""
for i in range(ml):
hexstr = hexstr ('x'% msg[i])
return hexstr
def Hash_sm3(msg Hexstr = 0):
if(Hexstr):
msg_byte = hex2byte(msg)
else:
msg_byte = str2byte(msg)
return hash_msg(msg_byte)
def KDF(Z klen): # Z为16进制表示的比特串（str），klen为密钥长度（单位byte）
klen = int(klen)
ct = 0x00000001
rcnt = ceil(klen/32)
Zin = hex2byte(Z)
Ha = ""
for i in range(rcnt):
msg = Zin hex2byte('x'% ct)
# print(msg)
Ha = Ha hash_msg(msg)
# print(Ha)
ct = 1
return Ha[0: klen * 2]
def sm3_max(s):
return Hash_sm3(s).upper()
def sm3_min(s):
return Hash_sm3(s)
#主显示框
if __name__=='__main__':
app = make_app()
app.mainloop()
希望对你有帮助 欢迎关注和收藏!
