import xlrd book = xlrd.open_workbook('ex.xls') print(book.nsheets) for n in book.sheet_names(): print(n)