按行获取值
from openpyxl import load_workbook
workbook = load_workbook(filename = "test.xlsx")
sheet = workbook.active
# 按行获取值
for i in sheet.iter_rows(min_row=1, max_row=3, min_col=1,max_col=3):
for j in i:
print(j.value)
按列获取值
from openpyxl import load_workbook
workbook = load_workbook(filename = "test.xlsx")
sheet = workbook.active
# 按列获取值
for i in sheet.iter_cols(min_row=1, max_row=3, min_col=1,max_col=3):
for j in i:
print(j.value)