getting sheet names from openpyxl

sheetnames
Returns the list of the names of worksheets in this workbook.
Names are returned in the worksheets order.
Type: list of strings

print (wb.sheetnames)

You can also get worksheet objects from wb.worksheets:

ws = wb.worksheets[0]

python excel openpyxl

python 3.xfor get sheet name you must use attribute

g_sheet=wb.sheetnames

return by list

for i in g_sheet:    print(i)

**shoose any name **

ws=wb[g_sheet[0]]

or ws=wb[any name]suppose name sheet is paster

ws=wb["paster"]

python excel openpyxl

As mentioned the earlier answeryou can get the list of sheet names by using the ws.sheetnames

But if you know the sheet names you can get that worksheet object by

ws.get_sheet_by_name("YOUR_SHEET_NAME")

Another way of doing this is as mentioned in earlier answer

ws['YOUR_SHEET_NAME']

CodeHunter