lokheart lokheart - 1 year ago 279
Python Question

how to read password protected excel in python

I'm new to python programming, and I am trying to read a password protected file using python, the code is shown below:

import sys
import win32com.client

xlApp = win32com.client.Dispatch("Excel.Application")
print "Excel library version:", xlApp.Version
filename,password = 'C:\myfiles\foo.xls', 'qwerty12'
xlwb = xlApp.Workbooks.Open(filename, Password=password)


But then the xls file is loaded but still prompt me to provide the password, I can't let python to enter the password for me.

What have I done wrong? Thanks!

Answer Source

Open takes two types of password, namely:

Password: password required to open a protected workbook.
WriteResPassword : password required to write to a write-reserved workbook

So in your case , is it write protected or protection on open?

Also there is a discussion on SO that says that this does not work with named parameters, So try providing all parameter values with the defaults

Default values are documented in MSDN

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download