python读取excel

zhangqinghao

import xlrd  
from xlrd import open_workbook  
def readsheet(s,row_count=-1,col_count=-1):  
    nrows=s.nrows  
    ncols=s.ncols  
    row_count=(row_count if row_count>0 else nrows)  
    col_count=(col_count if col_count>0 else ncols)  
    row_index=0  
    while row_index<row_count:  
        yield [s.cell(row_index,col).value for col in range(col_count)]  
        row_index+=1  
  
wb=open_workbook('F:\Python\matrix\matrix.xlsx')  
for s in wb.sheets():  
    for row in readsheet(s,10,10):  
        print(row)