to convert from letters to numberscall the openpyxl utils column_index_from _string(function to convert from numbers to letterscall the openpyxl utils get_column_letter(function enter the following into the interactive shellimport openpyxl from openpyxl utils import get_column_lettercolumn_index_from_string get_column_letter( translate column to letter 'aget_column_letter( 'bget_column_letter( 'aaget_column_letter( 'ahpwb openpyxl load_workbook('example xlsx'sheet wb['sheet 'get_column_letter(sheet max_column'ccolumn_index_from_string(' 'get ' number column_index_from_string('aa' after you import these two functions from the openpyxl utils moduleyou can call get_column_letter(and pass it an integer like to figure out what the letter name of the th column is the function column_index_string(does the reverseyou pass it the letter name of columnand it tells you what number that column is you don' need to have workbook loaded to use these functions if you wantyou can load workbookget worksheet objectand use worksheet attribute like max_column to get an integer thenyou can pass that integer to get_column_letter(getting rows and columns from the sheets you can slice worksheet objects to get all the cell objects in rowcolumnor rectangular area of the spreadsheet then you can loop over all the cells in the slice enter the following into the interactive shellimport openpyxl wb openpyxl load_workbook('example xlsx'sheet wb['sheet 'tuple(sheet[' ':' ']get all cells from to (()(<cell 'sheet >)()for rowofcellobjects in sheet[' ':' ']for cellobj in rowofcellobjectsprint(cellobj coordinatecellobj valueprint('--end of row ---' : :