安裝 msoffcrypto-tool
使用pip命令安裝: 打開命令行工具(如終端、命令提示符或Powershell),然后輸入以下命令來安裝msoffcrypto-tool:
pip install msoffcrypto-tool
庫,進行自動移除excel文件密碼
import msoffcrypto# 已加密Excel文件路徑
encrypted_file = "F:\解密前.xlsx"
# 未加密文件將保存的路徑
unencrypted_file = "F:\解密后.xlsx"
# Excel文件密碼
excel_password = "密碼"# 打開加密文件
with open(encrypted_file, "rb") as encrypted_file_fd:office_file = msoffcrypto.OfficeFile(encrypted_file_fd)# 使用密碼解密office_file.load_key(password=excel_password)# 將解密內容寫入新文件with open(unencrypted_file, "wb") as unencrypted_file_fd:office_file.decrypt(unencrypted_file_fd)print(f"文件已解密并保存至:{unencrypted_file}")