openpyxl get sheet by name

python openpyxl

You should use wb[sheetname]

from openpyxl import load_workbookwb2 = load_workbook('test.xlsx')ws4 = wb2["New Title"]

PS:You should check if your sheet in sheet names wb.sheetnames

print(wb2.sheetnames)['Sheet2', 'New Title', 'Sheet1']

python openpyxl

import openpyxln = 0wb = openpyxl.load_workbook('D:\excel.xlsx')sheets = wb.sheetnamesws = wb[sheets[n]]

CodeHunter