xxxxxxxxxx
data = pd.read_excel(r'File_Path', sheet_name='Name of Sheet')
xxxxxxxxxx
import pandas as pd
path = r"C:\Users\vho2\OneDrive - Exyte\Documents\Project2.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)