擅长:python、mysql、java
<p><a href="http://openpyxl.readthedocs.io/en/default/usage.html" rel="noreferrer">^{<cd1>}</a>提供开箱即用的容量。见<a href="http://openpyxl.readthedocs.io/en/default/usage.html#read-an-existing-workbook" rel="noreferrer">here</a>和<a href="http://openpyxl.readthedocs.io/en/default/pandas.html#converting-a-worksheet-to-a-dataframe" rel="noreferrer">here</a>。例如:</p>
<pre><code>from openpyxl import load_workbook
import pandas as pd
wb = load_workbook(filename = 'empty_book.xlsx')
sheet_names = wb.get_sheet_names()
name = sheet_names[0]
sheet_ranges = wb[name]
df = pd.DataFrame(sheet_ranges.values)
</code></pre>