you can get list of all the sheet names in the workbook by accessing the sheetnames attribute enter the following into the interactive shellimport openpyxl wb openpyxl load_workbook('example xlsx'wb sheetnames the workbook' sheetsnames ['sheet ''sheet ''sheet 'sheet wb['sheet 'get sheet from the workbook sheet type(sheetsheet title get the sheet' title as string 'sheet anothersheet wb active get the active sheet anothersheet each sheet is represented by worksheet objectwhich you can obtain by using the square brackets with the sheet name string like dictionary key finallyyou can use the active attribute of workbook object to get the workbook' active sheet the active sheet is the sheet that' on top when the workbook is opened in excel once you have the worksheet objectyou can get its name from the title attribute getting cells from the sheets once you have worksheet objectyou can access cell object by its name enter the following into the interactive shellimport openpyxl wb openpyxl load_workbook('example xlsx'sheet wb['sheet 'get sheet from the workbook sheet[' 'get cell from the sheet sheet[' 'value get the value from the cell datetime datetime( sheet[' 'get another cell from the sheet value 'applesget the rowcolumnand value from the cell 'row %scolumn % is % ( rowc columnc value'row column is apples'cell % is % ( coordinatec value'cell is applessheet[' 'value the cell object has value attribute that containsunsurprisinglythe value stored in that cell cell objects also have rowcolumnand coordinate attributes that provide location information for the cell