pd.read_excel

import pandas as pd
pd.read_excel('tmp.xlsx’, sheet_name='Sheet1')

Here is what the above code is Doing:
1. Importing the pandas library
2. Loading the Excel file into a variable called “df”
3. Displaying the first 5 rows of the dataframe