m0_59272561的博客

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

import openpyxlwb=openpyxl.Workbook()sheet=wb.activetxtName='my_life.txt'with open(txtName) as tObj: lines=tObj.readlines()for i in range(len(lines)): sheet.cell(column=1,row=i+1).value=lines[i]wb.save('my_life.xlsx')