擅长:python、mysql、java
<p>谢谢大家的投入!我需要的列表是由</p>
<pre><code>rdir=r"d:\temp"
import xlrd,spss
fils=[fil for fil in os.listdir(rdir) if fil.endswith(".xls")]
allData=[]
for cnt,fil in enumerate(fils):
wb=xlrd.open_workbook(os.path.join(rdir,fil))
ws=wb.sheets()[0]
for row in range(1,ws.nrows):
allData.append([fil]+[ws.name]+[val for val in ws.row_values(row)])
</code></pre>