TYPESCRIPT

read excel sheet in python

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

see sheets of excel file python

xl = pd.ExcelFile('foo.xls')

xl.sheet_names

new sheets on excel file python

from openpyxl.workbook import Workbook
 
wb = Workbook()
ws1 = wb.create_sheet("Sheet_A")
ws1.title = "Title_A"

ws2 = wb.create_sheet("Sheet_B", 0)
ws2.title = "Title_B"

wb.save(filename = 'sample_book.xlsx')