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')