使用Python为Excel文件设置密码 [英] Set Password for excel file using Python

问题描述

我正在尝试为使用openpyxl生成的excel文件设置密码.我经历了 openpyxl . Openpyxl具有工作簿保护功能，但是不像MS Excel中那样使用密码支持整个工作簿锁定.我还查看了 xlsxwriter ， xlrd ， xlwt .

I am trying to set password for excel file generated using openpyxl. I went through openpyxl. Openpyxl has a workbook protection functionality, but it does not support whole workbook lock using password as it does in MS Excel. I also looked into xlsxwriter, xlrd, xlwt.

python中有什么方法可以为Excel文件设置密码吗?

Is there any way in python which i can set password for an excel file ?

谢谢.

推荐答案

可以尝试使用以下代码

from openpyxl import Workbook
wb = Workbook()

ws=wb.worksheets[0]
ws.protection.set_password('test')
wb.save('sample.xlsx')

这篇关于使用Python为Excel文件设置密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！