擅长:python、mysql、java
<p>我想我应该在这里补充一点,如果您想访问行或列来循环它们,可以这样做:</p>
<pre><code>import pandas as pd
# open the file
xlsx = pd.ExcelFile(PATH\FileName.xlsx)
# get the first sheet as an object
sheet1 = xlsx.parse(0)
# get the first column as a list you can loop through
# where the is 0 in the code below change to the row or column number you want
column = sheet1.icol(0).real
# get the first row as a list you can loop through
row = sheet1.irow(0).real
</code></pre>
<hr/>
<p><strong>编辑:</strong></p>
<p>方法<code>icol(i)</code>和<code>irow(i)</code>现在已被弃用。可以使用<code>sheet1.iloc[:,i]</code>获取第i列,使用<code>sheet1.iloc[i,:]</code>获取第i行。</p>