Amazing! The cell's value is not the only data we can obtain from it. There are also row, column, and coordinate data:
ws["A1"].row ws["A1"].column ws["A1"].coordinate
The row property returns an integer that indicates the row number of a given cell. The column property returns the number (not letter) of a column. The coordinate property returns the cell's complete location, in A1 notation.
Run the code in the Code Editor. Observe the row, column, and coordinate properties for the B4 cell.
wb = load_workbook("january_diet.xlsx")ws = wb["summary"]cell = ws["B4"]print(cell.row, cell.column, cell.coordinate)
