title: From Password Protected Excel File to Python Object
body: <p>I am using Windows 7, Python 2.7 and Microsoft Excel 2013.</p>
  <p>I know from <a href="https://stackoverflow.com/questions/15285068/from-password-protected-excel-file-to-pandas-dataframe#_=_">here</a> that I can open and access a password protected Excel sheet using the below sample code:</p>
  <pre><code>import sys
  import win32com.client
  xlApp = win32com.client.Dispatch(&quot;Excel.Application&quot;)
  print &quot;Excel library version:&quot;, 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 would like to save an Excel worksheet from a password protected file as a Python object. Ideally it would be saved as a <code>pandas dataframe</code> but I would be OK to have it as a dictionary or any other object type.</p>
  <p>I have the password. Is this possible?</p>
  <p>Thanks!</p>