work_book = xlrd.open_workbook(r"c:\1.xls")
sheet1 = work_book.sheet_by_index(0)
nRows = sheet1.nrows
nCols = sheet1.ncols
print("总共行：",nRows,"，总共列：",nCols)