Pandas to_excel不写换行符

import pandas as pd
from openpyxl import Workbook

# 创建一个DataFrame
data = {'Name': ['John Doe', 'Jane Smith', 'Bob Johnson'],
        'Age': [30, 25, 35],
        'City': ['New York', 'London', 'Paris'],
        'Description': ['First line\nSecond line', 'Third line', 'Fourth line']}

df = pd.DataFrame(data)

# 创建一个ExcelWriter对象
writer = pd.ExcelWriter('output.xlsx', engine='openpyxl')

# 将DataFrame写入Excel文件
df.to_excel(writer, sheet_name='Sheet1', index=False)

# 获取Excel文件的工作簿对象
workbook = writer.book

# 获取Sheet对象
worksheet = writer.sheets['Sheet1']

# 设置单元格的wrap_text属性为True
for column_cells in worksheet.columns:
    for cell in column_cells:
        cell.alignment = cell.alignment.copy(wrapText=True)

# 保存Excel文件
writer.save()

import pandas as pd

# 创建一个DataFrame
data = {'Name': ['John Doe', 'Jane Smith', 'Bob Johnson'],
        'Age': [30, 25, 35],
        'City': ['New York', 'London', 'Paris'],
        'Description': ['First line\nSecond line', 'Third line', 'Fourth line']}

df = pd.DataFrame(data)

# 创建一个ExcelWriter对象
writer = pd.ExcelWriter('output.xlsx', engine='xlsxwriter')

# 将DataFrame写入Excel文件
df.to_excel(writer, sheet_name='Sheet1', index=False)

# 获取Workbook对象
workbook = writer.book

# 获取Worksheet对象
worksheet = writer.sheets['Sheet1']

# 设置单元格的wrap_text属性为True
wrap_format = workbook.add_format({'text_wrap': True})
worksheet.set_column('D:D', None, wrap_format)

# 保存Excel文件
writer.save()