import xlrd

#打開(kāi)一個(gè)xls文件

workbook = xlrd.open_workbook('test.xls')

#抓取所有sheet頁(yè)的名稱

worksheets = workbook.sheet_names()

print('worksheets is %s' %worksheets)

#定位到sheet1

worksheet1 = workbook.sheet_by_name(u'Sheet1')

'''

#通過(guò)索引順序獲取

worksheet1 = workbook.sheets()[0]

#或

worksheet1 = workbook.sheet_by_index(0)

'''

'''

#遍歷所有sheet對(duì)象

for worksheet_name in worksheets:

worksheet = workbook.sheet_by_name(worksheet_name)

'''

#遍歷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