pandas.read_excel() reads an Excel worksheet from an Excel workbook. See also pandas' ExcelFile and ExcelWriter objects import pandas as pd
import os
xls_sheet_1 = pd.read_excel(
'file:///' + os.getcwd() + '/pandas.xlsx' ,
sheet_name = 'data one')