****目前已有代码:****
import msoffcrypto
import io
import pandas as pd
file = msoffcrypto.OfficeFile(open("123.xlsx", "rb"))
file.load_key(password="123456")
decrypted = io.BytesIO()
file.decrypt(decrypted)
df = pd.read_excel(decrypted)
print(df)
data = pd.concat([df0, df1, ...], axis=0)
存在问题:1、如果我想打开的是一个文件夹下面的多个文件,请问一下这个代码:file = msoffcrypto.OfficeFile(open("encrypted.xlsx", "rb"))该如何修改一下,
2、还有在合并的时候会提示 name 'df0' is not defined