title: read encrypted excel with pandas
body: <p>I am scanning data through encrypted excel files with python. I would like to read the file content without opening excel. Here is my code. I usually use pandas to read files but pandas.read_excel do not allows to add password.</p>
  
  <pre><code>from xlrd import *
  import win32com.client
  import csv
  import sys
  
  xlApp = win32com.client.Dispatch("Excel.Application")
  xlwb = xlApp.Workbooks.Open(path1+file_name, Password='password')
  </code></pre>
  
  <p>Thank you</p>