Python-Excel-openpyxl-10-按行或者按列遍历

import os
from openpyxl import load_workbook

root_address = os.path.dirname(os.path.abspath(__file__))

excel_name = r"openpyxl示例_10.xlsx"
excel_address = os.path.join(root_address, excel_name)
print(excel_address)

wb = load_workbook(excel_address)
sht = wb.worksheets[0]

col = sht["A"]

i = 0
for cell in col:
    i += 1
    print("i=", i)
    print("单元格内值", cell.value)

print("\n相隔3行\n")

row1 = sht[1]
row2 = sht[2]

j = 0
for cell in row1:
    j += 1
    print("j=", j)
    print("单元格内值", cell.value)

print("\n相隔3行\n")

k = 0
for cell in row2:
    k += 1
    print("k=", k)
    print("单元格内值", cell.value)