隐藏密码以从受保护的excel文件中获取数据，而无需用户干预。

import pandas as pd

# 预设密码
password = 'your_secure_password'

# 读取受保护的Excel文件
xls = pd.ExcelFile('protected_file.xlsx', engine='openpyxl')
sheet_names = xls.sheet_names

# 逐个读取工作表
for sheet in sheet_names:
    df = pd.read_excel(xls, sheet_name=sheet, password=password)
    print(df.head())

from openpyxl import load_workbook

# 加载受保护的Excel文件
wb = load_workbook(filename='protected_file.xlsx', read_only=True, keep_links=False)

# 移除密码保护
wb.security.lockStructure = False

# 保存为无密码的新文件
wb.save('unprotected_file.xlsx')

import pandas as pd
from cryptography.fernet import Fernet

# 生成密钥并加密密码
key = Fernet.generate_key()
cipher_suite = Fernet(key)
password = b'your_secure_password'
encrypted_password = cipher_suite.encrypt(password)

# 解密密码
decrypted_password = cipher_suite.decrypt(encrypted_password).decode()

# 使用解密后的密码读取Excel文件
xls = pd.ExcelFile('protected_file.xlsx', engine='openpyxl')
sheet_names = xls.sheet_names

for sheet in sheet_names:
    df = pd.read_excel(xls, sheet_name=sheet, password=decrypted_password)
    print(df.head())