title: From password-protected Excel file to pandas DataFrame
body: <p>I can open a password-protected Excel file with this:</p>
  
  <pre><code>import sys
  import win32com.client
  xlApp = win32com.client.Dispatch("Excel.Application")
  print "Excel library version:", xlApp.Version
  filename, password = sys.argv[1:3]
  xlwb = xlApp.Workbooks.Open(filename, Password=password)
  # xlwb = xlApp.Workbooks.Open(filename)
  xlws = xlwb.Sheets(1) # counts from 1, not from 0
  print xlws.Name
  print xlws.Cells(1, 1) # that's A1
  </code></pre>
  
  <p>I'm not sure though how to transfer the information to a pandas dataframe. Do I need to read cells one by one and all, or is there a convenient method for this to happen?</p>