import openpyxl

wb = openpyxl.load_workbook("data.xlsx", data_only=True)
ws = wb["Sheet1"]
for row in ws.iter_rows(values_only=True):
    print(row)

rows = list(ws.iter_rows(values_only=True))
head = rows[0]
for r in rows[1:]:
    record = "；".join(f"{h}：{v}" for h, v in zip(head, r) if v is not None)
    print(record[:120])