python给excel文件加密并重新生成文件

需安装pywin32

pip install pywin32

直接上源码。简单几行就搞定

import os, sys
import win32com.client
import time
import hashlib

def pwd_xlsx(old_filename,new_filename,pwd_str,pw_str=''):
    xcl = win32com.client.Dispatch("Excel.Application")
    # pw_str为打开密码, 若无 访问密码, 则设为 ''
    wb = xcl.Workbooks.Open(old_filename, False, False, None, pw_str)
    xcl.DisplayAlerts = False

    # 保存时可设置访问密码.
    wb.SaveAs(new_filename, None, pwd_str, '')

    xcl.Quit()

if __name__ == '__main__':
    old_filename = 'C:\\Users\\admin\Desktop\\20200805.xlsx'
    new_filename = 'C:\\Users\\admin\Desktop\\test122222.xlsx'
    pwd_str = '654321'#新密码自定义
    pwd_xlsx(old_filename,new_filename,pwd_str)

本文地址：https://blog.csdn.net/lttisky/article/details/108236732