import xlrd book = xlrd.open_workbook('ex.xls') print(book.nsheets) shx = book.sheet_by_index(0) print (shx.ncols) print(shx.nrows)