read excel sheet in python

1df = pd.read_excel('Path.xlsx', sheet_name='Desired Sheet Name')

1import pandas as pd
2
3df = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx', sheet_name='your Excel sheet name')
4print (df)
5

1import pandas as pd
2
3df = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx')

1xl = pd.ExcelFile('foo.xls')
2
3xl.sheet_names

1import pandas as pd
2
3df = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx')
4print (df)
5

1import os
2from pathlib import Path
3# opening EXCEL through Code
4					#local path in dir
5absolutePath = Path('../excel.xlsx').resolve()
6os.system(f'start excel.exe "{absolutePath}"')