import pandas as pd path = ('...filename.xlsx') xl = pd.ExcelFile(path) print(xl.sheet_names)
df1 = xl.parse('Sheet1')