import openpyxl
import msoffcrypto
#读取
# rb = openpyxl.load_workbook('./123.xlsx')
#遍历读取
# rb = openpyxl.load_workbook('./ExportOrderList12224592231.xlsx')
# rba = rb.active
#读数加密并遍历文件存在则覆盖 不存在就创建新的文件
encrypted = open("./ExportOrderList12224592231.xlsx", "rb")
file = msoffcrypto.OfficeFile(encrypted)
file.load_key(password="spF6Vz29")
with open("./000000.xlsx", "wb") as f:
file.decrypt(f)
encrypted.close()
#读取有密码的文档
# for aaa in rb.worksheets[0].values:
# print(aaa)
#激活当前工作表
# rba = rb.active
# rba['A1'] = "sydomain"
# rb.save('./sy.xlsx')pip3 install -i https://pypi.tuna.tsinghua.edu.cn/simple msoffcrypto-tool
pip3 install openpyxl