解密excel文件 [英] decrypt excel files
问题描述
我有 1000 个加密的工作簿,我想通过提供密码来解密.我在apache poi或python的xlrd模块下找不到解密方法.
Hi I have 1000 encrypted workbooks which I would like to decrypt by providing a pwd. I could not find a decrypt method under apache poi or python's xlrd module.
有谁知道可以处理这个问题的库(wbc.decrypt(pwd)
).我更喜欢我可以从 unix 框中使用的库.
Does anyone know a library which could handle this (wbc.decrypt(pwd)
). I would prefer a lib i could you use from a unix box.
谢谢
推荐答案
使用 COM 绑定调用 Unprotect
方法.
Use the COM bindings to call the Unprotect
method.
import win32com.client
excel = win32com.client.Dispatch('Excel.Application')
workbook = excel.Workbooks.open(r'c:\mybook.xls', 'password')
workbook.SaveAs('unencrypted.xls')
另存为可以应用新密码.请参阅:http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas%28VS.80%29.aspx
SaveAs can apply a new password. See: http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas%28VS.80%29.aspx
这篇关于解密excel文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!