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