Breaking News: Grepper is joining You.com. Read the official announcement!

read password protected excel file in python

Graceful Goose answered on April 27, 2023 Popularity 4/10 Helpfulness 2/10

answer read password protected excel file in python

read password protected excel file in python

Comment

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)

Popularity 4/10 Helpfulness 2/10 Language python

Source: Grepper

Tags: excel file protected python

Link to this answer
Share Copy Link

Contributed on Apr 27 2023

Graceful Goose

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

read password protected excel file in python

Contents

More Related Answers

read password protected excel file in python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.