title: How to open a password protected excel file using python?
body: <p>I looked at the previous threads regarding this topic, but they have not helped solve the problem.  </p>
  
  <ul>
  <li><p><a href="https://stackoverflow.com/questions/3783980/how-to-read-password-protected-excel-in-python">how to read password protected excel in python</a></p></li>
  <li><p><a href="https://stackoverflow.com/questions/2887339/how-to-open-write-reserved-excel-file-in-python-with-win32com">How to open write reserved excel file in python with win32com?</a></p></li>
  </ul>
  
  <p>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...</p>
  
  <pre><code>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)
  </code></pre>