python excel 设置单元强制换行

from openpyxl import Workbook
from openpyxl.styles import Alignment

wb = Workbook()
sheet = wb.active
sheet['G1'] = "Line 1\nLine 2\nLine 3"
sheet['G1'].alignment = Alignment(wrapText=True)


if __name__ == '__main__':
    wb.save("sample.xlsx")

posted @ 2023-03-06 16:41  vx_guanchaoguo0  阅读(180)  评论(0编辑  收藏  举报