import openpyxl
import pandas as pd
import io
import msoffcrypto
decrypted_workbook = io.BytesIO()
with open(read_filename, 'rb') as file:
office_file = msoffcrypto.OfficeFile(file)
office_file.load_key(password='123@')
office_file.decrypt(decrypted_workbook)
# `filename` can also be a file-like object.
workbook = openpyxl.load_workbook(filename=decrypted_workbook)
worksheet = workbook.worksheets[0]
# Reading data from worksheet to pandas dataframe
data_rows = []
for row in worksheet.iter_rows(values_only=True):
data_rows.append(row)
# Create a DataFrame from the list of rows
df = pd.DataFrame(data_rows)