Python遍历excle

#遍历sheet1中所有行row
num_rows = worksheet1.nrows
for curr_row in range(num_rows):
row = worksheet1.row_values(curr_row)
print(‘row%s is %s‘ %(curr_row,row))

#遍历sheet1中所有列col
num_cols = worksheet1.ncols
for curr_col in range(num_cols):
col = worksheet1.col_values(curr_col)
print(‘col%s is %s‘ %(curr_col,col))

#遍历sheet1中所有单元格cell

for rown in range(num_rows):
for coln in range(num_cols):
cell = worksheet1.cell_value(rown,coln)
print cell

Python遍历excle

原文：https://www.cnblogs.com/HOWX/p/13946948.html