是否有一种简单的(免费)方式来加密Python的Excel工作簿?
我需要自动发送许多Excel工作簿,但对安全性有一些疑问。我想密码在每个工作簿交付之前保护它们。 python中需要发生这种加密过程
吗?我遇到了OpenPyXl,但是,密码保护似乎无法完全工作。即打开时不需要密码。
from openpyxl import Workbook
from openpyxl import load_workbook
test_spreadsheet = "test.xlsx"
wb = Workbook()
wb.security.workbookPassword = 'password'
wb.security.lockStructure = True
wb.save(test_spreadsheet)
I need to automate sending of a number of Excel Workbooks but have slight concerns about security. I would like to password protect each workbook before they are delivered. This encryption process would need to occur in python
Is there a simple way of doing it? I've come across Openpyxl, however, the password protection doesn't seem to work fully. i.e. no password is required on opening.
from openpyxl import Workbook
from openpyxl import load_workbook
test_spreadsheet = "test.xlsx"
wb = Workbook()
wb.security.workbookPassword = 'password'
wb.security.lockStructure = True
wb.save(test_spreadsheet)
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论