title: how to read password protected excel in python
body: <p>I'm new to python programming, and I am trying to read a password protected file using python, the code is shown below:</p>
  
  <pre><code>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)
  </code></pre>
  
  <p>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.</p>
  
  <p>What have I done wrong? Thanks!</p>