how to read xlsx file in jupyter notebook code example

Example 1: how to read xlsx file in jupyter notebook

df1 = xl.parse('Sheet1')

Example 2: how to read xlsx file in jupyter notebook

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