python调用excel数据并显示

python安装xlrd第三方库（安装步骤在上一篇有讲过）。然后通过xlrd库调用excel数据。

import xlrdfname = "F:\Python\matrix\matrix.xlsx"bk = xlrd.open_workbook(fname)#open_workbookshxrange = range(bk.nsheets)#rangeprint(shxrange)try:#try    sh = bk.sheet_by_name("Sheet1")except:    print("no sheet in %s named Sheet1")nrows = sh.nrowsncols = sh.ncolsprint(nrows)print(ncols)a=sh.row_values(1)#read row valuesprint(a)print(sh.row(1)[0].value)#read dataprint(sh.row(1)[0].ctype)#ctype:0:empty;1:string;2:number,3:date,4:boolean,5:error

代码后面有相应注释，有不理解的可以提出来哈