Openpyxl already has a proper way to iterate through rows using worksheet.iter_rows() . You can use it to unpack the first cell's value as the key ...
how-to-iterate-through-excel-rows-in-python
3925e8d270
iterate through excel rows python pandas, iterate through excel rows python, iterate through excel rows python openpyxl, iterate over excel rows python, iterate over excel rows python pandas, loop through excel cells python