openpyxl iter_rows() 获取单元格值

最新推荐文章于 2025-04-13 08:51:23 发布

U盘失踪了

最新推荐文章于 2025-04-13 08:51:23 发布

阅读量1w

点赞数 3

分类专栏：办公自动化文章标签： python

本文链接：https://blog.csdn.net/qq_26086231/article/details/123285921

版权

办公自动化专栏收录该内容

21 篇文章

订阅专栏

按行获取值

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)