选择当前活动的execel单元格

md5加密工具怎么用(execel批量MD5加密工具 和 SM3批量加密工具)(1)

md5加密工具怎么用(execel批量MD5加密工具 和 SM3批量加密工具)(2)

打开MD5加密工具---因为不是美工,做工比较粗糙,请见谅,但是很实用!

md5加密工具怎么用(execel批量MD5加密工具 和 SM3批量加密工具)(3)

选择文件

md5加密工具怎么用(execel批量MD5加密工具 和 SM3批量加密工具)(4)

选择要加密的列

md5加密工具怎么用(execel批量MD5加密工具 和 SM3批量加密工具)(5)

md5加密工具怎么用(execel批量MD5加密工具 和 SM3批量加密工具)(6)

加密成功后结果如下:

md5加密工具怎么用(execel批量MD5加密工具 和 SM3批量加密工具)(7)

代码如下:

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("%08x" % 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 = "%08x" % W[j] W_1 = [] for j in range(0, 64): W_1.append(0) W_1[j] = W[j] ^ W[j+4] str1 = "%08x" % 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 = "%02d" % 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 = '%s%08x' % (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 + ('%02x'% 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('%08x'% 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()

md5加密工具怎么用(execel批量MD5加密工具 和 SM3批量加密工具)(8)

希望对你有帮助