python处理Excel文件，,#coding=utf-

python处理Excel文件，,#coding=utf-

#coding=utf-8########################################################filename:test_xlrd.py#author:defias#date:xxxx-xx-xx#function：读excel文件中的数据#######################################################import xlrd#打开一个workbookworkbook = xlrd.open_workbook('E:\\Code\\Python\\testdata.xls')#抓取所有sheet页的名称worksheets = workbook.sheet_names()print('worksheets is %s' %worksheets)#定位到sheet1worksheet1 = workbook.sheet_by_name(u'Sheet1')"""#通过索引顺序获取worksheet1 = workbook.sheets()[0]#或worksheet1 = workbook.sheet_by_index(0)""""""#遍历所有sheet对象for worksheet_name in worksheets:    worksheet = workbook.sheet_by_name(worksheet_name)"""#遍历sheet1中所有行rownum_rows = worksheet1.nrowsfor curr_row in range(num_rows):    row = worksheet1.row_values(curr_row)    print('row%s is %s' %(curr_row,row))#遍历sheet1中所有列colnum_cols = worksheet1.ncolsfor curr_col in range(num_cols):    col = worksheet1.col_values(curr_col)    print('col%s is %s' %(curr_col,col))#遍历sheet1中所有单元格cellfor rown in range(num_rows):    for coln in range(num_cols):        cell = worksheet1.cell_value(rown,coln)        print cell"""        #其他写法：        cell = worksheet1.cell(rown,coln).value        print cell        #或        cell = worksheet1.row(rown)[coln].value        print cell        #或        cell = worksheet1.col(coln)[rown].value        print cell        #获取单元格中值的类型，类型 0 empty,1 string, 2 number, 3 date, 4 boolean, 5 error        cell_type = worksheet1.cell_type(rown,coln)        print cell_type"""