如何通过openpyxl官方文档解决自动换行的弃用警告问题

Hey there, let's work through this deprecation warning issue with openpyxl's text wrapping, and also clarify how to find the correct approach in the official docs.

为什么会出现这个警告？ #

Your code uses the copy() method on the cell.alignment object, which openpyxl has deprecated. The warning message even gives a hint: "Use copy(obj) or cell.obj = cell.obj + other" — we'll break down what that means and how to apply it properly.

如何在官方文档中找到正确方法？ #

Navigating the openpyxl docs can feel tricky at first, so here's a step-by-step path:

• Head to the Styles and Formatting section (this is where all cell formatting logic lives).
• Locate the documentation for the Alignment class — this is the class that controls text wrapping, horizontal/vertical alignment, etc.
• Look at the class's attributes: you'll see wrap_text (note the snake_case naming, not the old camelCase wrapText) is the official property for text wrapping.
• Scroll to the section about style merging: the docs explicitly state that you can combine style objects using the + operator, which is the recommended replacement for the old copy() method.

修正后的代码（两种可行方式） #

方式1：样式合并（官方推荐，最简洁）

This uses the cell.obj = cell.obj + other pattern mentioned in the warning. We create a minimal Alignment object with just wrap_text=True, then merge it with the cell's existing alignment to preserve other settings:

from openpyxl import load_workbook
from openpyxl.styles import Alignment

# 注意加r前缀避免Windows路径转义问题
file1 = r"C:\folder\inputFile1.xlsx"
wb = load_workbook(file1)
ws = wb.active

# 遍历第10行及以后的所有单元格
for row in ws.iter_rows(min_row=10):
    for cell in row:
        # 创建仅设置自动换行的对齐对象
        wrap_style = Alignment(wrap_text=True)
        # 合并原有样式和新的自动换行样式
        cell.alignment = cell.alignment + wrap_style

wb.save(r"C:\folder\file1_wrap.xlsx")

方式2：复制并修改属性（更直观，适合需要精细控制的场景）

If you prefer to explicitly copy all existing alignment properties and adjust just wrap_text, you can use Python's built-in copy module (which the warning's copy(obj) refers to):

from openpyxl import load_workbook
from openpyxl.styles import Alignment
import copy

file1 = r"C:\folder\inputFile1.xlsx"
wb = load_workbook(file1)
ws = wb.active

for row in ws.iter_rows(min_row=10):
    for cell in row:
        # 复制原有对齐对象
        new_alignment = copy.copy(cell.alignment)
        # 修改自动换行属性
        new_alignment.wrap_text = True
        # 重新赋值给单元格
        cell.alignment = new_alignment

wb.save(r"C:\folder\file1_wrap.xlsx")

关键细节说明 #

• The old wrapText camelCase parameter still works for backward compatibility, but the official property name now is wrap_text (snake_case) — it's better to use this going forward.
• When using the + operator to merge styles, any properties set in the second style object will override the corresponding properties in the first, while all other properties are preserved. This is exactly what the old copy() method was doing, but in a cleaner, supported way.

内容的提问来源于stack exchange，提问作者Kierk