如何在使用Python打开Excel文件时输入密码？

Question

from openpyxl.workbook.protection import WorkbookProtection
import openpyxl as xl
wb = xl.load_workbook(path, keep_vba=True)

wb.security = WorkbookProtection()
wb.security.workbookPassword = 'test_password'
wb.security.lockStructure = True

ws = wb.active
# some code 
wb.save(filename=path)

我尝试使用上面的代码对Excel文件进行密码保护。没有错误，但也没有密码提示

有人能帮忙吗