How to open a password protected excel file using python?

Question

I reviewed previous topics regarding this topic, but they did not help solve the problem.

• how to read password protected excel in python

• How to open a reserved excel file in python using win32com?

I am trying to open a password protected file in excel without any user interaction. I searched the Internet and found this code that uses win32com.client. When I run this, I still get a password prompt ...

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 don't think named parameters work in this case. So you will need to do something like:

xlwb = xlApp.Workbooks.Open( , False, True, None, password)

Workbooks.Open . http://msdn.microsoft.com/en-us/library/office/ff194819.aspx.

Answer 2

Openpyxl Package , Linux. , , .

: https://www.quora.com/How-do-I-open-read-password-protected-xls-or-xlsx-Excel-file-using-python-in-Linux