read encrypted excel with pandas
<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>