Python openpyxl单元格读取详解：多种读取方式与实战教程

# 按坐标读取
ws['A1'].value

# 按行列索引读取
ws.cell(row=1, column=1).value

# 行迭代
for row in ws.iter_rows():
    for cell in row:
        cell.value

# 列迭代
for col in ws.iter_cols():
    for cell in col:
        cell.value

from openpyxl import Workbook

wb = Workbook()
ws = wb.active

# 写入测试数据
data = [
    ['姓名', '年龄', '城市'],
    ['张三', 25, '北京'],
    ['李四', 30, '上海'],
    ['王五', 28, '广州']
]
for row in data:
    ws.append(row)

# 方式1：坐标读取
print(f"ws['A1'] = {ws['A1'].value}")
print(f"ws['B2'] = {ws['B2'].value}")

# 方式2：cell()方法读取
print(f"cell(1,1) = {ws.cell(row=1, column=1).value}")
print(f"cell(2,2) = {ws.cell(row=2, column=2).value}")

# 读取单元格属性
cell = ws['A1']
print(f"\n单元格坐标: {cell.coordinate}")
print(f"行号: {cell.row}, 列号: {cell.column}")
print(f"数据类型: {type(cell.value)}")

ws['A1'] = 姓名
ws['B2'] = 25
cell(1,1) = 姓名
cell(2,2) = 25

单元格坐标: A1
行号: 1, 列号: 1
数据类型: <class 'str'>

from openpyxl import Workbook

wb = Workbook()
ws = wb.active

data = [['编号', '名称', '价格'],
        [1, '苹果', 5.5],
        [2, '香蕉', 3.2],
        [3, '橙子', 4.8]]
for row in data:
    ws.append(row)

# 遍历所有行（返回Cell对象）
print("iter_rows():")
for row in ws.iter_rows(min_row=1, max_row=4):
    values = [cell.value for cell in row]
    print(f"  {values}")

# values_only=True只返回值
print("\niter_rows(values_only=True):")
for row in ws.iter_rows(values_only=True):
    print(f"  {row}")

# 读取指定范围
print("\n只读取数据区域（跳过表头）:")
for row in ws.iter_rows(min_row=2, values_only=True):
    print(f"  {row}")

iter_rows():
  ['编号', '名称', '价格']
  [1, '苹果', 5.5]
  [2, '香蕉', 3.2]
  [3, '橙子', 4.8]

iter_rows(values_only=True):
  ('编号', '名称', '价格')
  (1, '苹果', 5.5)
  (2, '香蕉', 3.2)
  (3, '橙子', 4.8)

只读取数据区域（跳过表头）:
  (1, '苹果', 5.5)
  (2, '香蕉', 3.2)
  (3, '橙子', 4.8)

from openpyxl import Workbook

wb = Workbook()
ws = wb.active

data = [['姓名', '部门', '工资'],
        ['张三', '技术部', 15000],
        ['李四', '市场部', 12000],
        ['王五', '技术部', 18000],
        ['赵六', '财务部', 13000]]
for row in data:
    ws.append(row)

# 列迭代
print("iter_cols():")
for col in ws.iter_cols(min_col=1, max_col=3, values_only=True):
    print(f"  {col}")

# 条件读取：工资大于13000的员工
print("\n工资>13000的员工:")
for row in ws.iter_rows(min_row=2, values_only=True):
    if row[2] > 13000:
        print(f"  {row[0]}: {row[2]}")

# 读取特定列
print("\n只读取姓名和工资:")
for row in ws.iter_rows(min_row=2, min_col=1, max_col=3, values_only=True):
    print(f"  {row[0]}: {row[2]}")

iter_cols():
  ('姓名', '张三', '李四', '王五', '赵六')
  ('部门', '技术部', '市场部', '技术部', '财务部')
  ('工资', 15000, 12000, 18000, 13000)

工资>13000的员工:
  张三: 15000
  王五: 18000

只读取姓名和工资:
  张三: 15000
  李四: 12000
  王五: 18000
  赵六: 13000