How to open a password protected excel file using python

Question

I looked at the previous threads regarding this topic, but they have not helped solve the problem.

• how to read password protected excel in python

• How to open write reserved excel file in python with win32com?

I'm trying to open a password protected file in excel without any user interaction. I searched online, and found this code which uses win32com.client When I run this, I still get the prompt to enter the password...

from xlrd import *
import win32com.client
import csv
import sys

xlApp = win32com.client.Dispatch("Excel.Application")
print "Excel library version:", xlApp.Version
filename,password = r"\\HRA\Myfile.xlsx", 'caa team'
xlwb = xlApp.Workbooks.Open(filename, Password=password)

Answer 1

I recently came upon a Python package that simplifies this process.

It doesn't require Excel to run, and it's also cross-platform because it's written in Python.

Microsoft Office password-protected (encrypted) documents, including the older XLS binary file format, are supported by msoffcrypto-tool.

Install msoffcrypto-tool:

 pip install msoffcrypto-tool

From the command line, you might make an unencrypted version of the workbook:

msoffcrypto-tool Myfile.xlsx Myfile-decrypted.xlsx -p "caa team"