使用python,xlwing模块解决excel文档加密

废话不多说,直接上代码

import xlwings

app = xlwings.App()
app.visible = False
ex = app.books.open("ceshi.xlsx")

ex.save("ceshi.xlsx", password="123456")

app.quit()