import pandas as pd path = r"C:Usersvho2OneDrive - ExyteDocumentsProject2.xlsx" x = pd.read_excel(path,sheet_name=None) #get all sheet name in the excel file names = x.keys() # get count names count = len(names) print(count)