import openpyxl
wb=openpyxl.load_workbook('test.xlsx')
sheet=wb.active
for r in sheet:
for c in r:
c.alignment=openpyxl.styles.Alignment(wrapText=True)
wb.save('test.xlsx')
关键词 alignment, wrapText=True
import openpyxl
wb=openpyxl.load_workbook('test.xlsx')
sheet=wb.active
for r in sheet:
for c in r:
c.alignment=openpyxl.styles.Alignment(wrapText=True)
wb.save('test.xlsx')
关键词 alignment, wrapText=True