I looked at the previous threads regarding this topic, but they have not helped solve the problem.
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"\HRAMyfile.xlsx", 'caa team' xlwb = xlApp.Workbooks.Open(filename, Password=password)
I don’t think that named parameters work in this case. So you’d have to do something like:
xlwb = xlApp.Workbooks.Open(filename, False, True, None, password)
See http://msdn.microsoft.com/en-us/library/office/ff194819.aspx for details on the Workbooks.Open method.
If your file size is small, you can probably save that as “.csv”.
and then read
It worked for me 🙂
Openpyxl Package works if you are using linux system. You can use secure the file by setting up a password and open the file using the same password.
For more info: