擅长:python、mysql、java
<p>从大卫哈曼的网站(所有学分归他)
<a href="https://davidhamann.de/2018/02/21/read-password-protected-excel-files-into-pandas-dataframe/" rel="nofollow noreferrer">https://davidhamann.de/2018/02/21/read-password-protected-excel-files-into-pandas-dataframe/</a></p>
<p>使用xlwings,打开文件将首先启动Excel应用程序,以便您可以输入密码。</p>
<pre><code>import pandas as pd
import xlwings as xw
PATH = '/Users/me/Desktop/xlwings_sample.xlsx'
wb = xw.Book(PATH)
sheet = wb.sheets['sample']
df = sheet['A1:C4'].options(pd.DataFrame, index=False, header=True).value
df
</code></pre>