Python openpyxl写excel文件

fromopenpyxlimportWorkbookfromopenpyxl.stylesimportNamedStyle,Font,PatternFill,Border,Side,Alignmentfromopenpyxl.utilsimportget_column_letterif__name____main__:wbWorkbook()# 创建工作簿对象wswb.active ws.titleSheet1header[设备ID,VIN,包名,车型代码,品牌,事件源版本,事件目标版本,最后访问日期]ws.append(header)data_list[(VIN:KMHKNXXXXXXXXXXXX_AVNT,KMHKNXXXXXXXXXXXX,XXXXX^ICHN^01,XXXXX,H,PXXXXPCEXXICHN10_008,PXXXXPCEXXICHN10_012,2026-04-10 05:46:15),(VIN:KMHKNXXXXXXXXXXXX_AVNT,KMHKNXXXXXXXXXXXX,XXXXX^ICHN^01,XXXXX,H,PXXXXPCEXXICHN10_008,PXXXXPCEXXICHN10_012,2026-04-10 05:44:03)]foritemindata_list:ws.append(item)forcolinrange(1,ws.max_column1):# 遍历所有列column_letterget_column_letter(col)column_max_lengthmax(len(cell.value)forcellinws[column_letter])ws.column_dimensions[column_letter].widthmax(column_max_length,len(header[col-1])*2)2# 自动调整宽度以适应内容header_styleNamedStyle(nameHeaderStyle,fontFont(colorFFFFFF,boldTrue),borderBorder(leftSide(stylethin,color000000),rightSide(stylethin,color000000)),fillPatternFill(start_colorFF666699,end_colorFF666699,fill_typesolid),alignmentAlignment(horizontalcenter,verticalcenter))forcellinws[1:1]:cell.styleheader_style wb.save(C:\\Users\\Admin\\Downloads\\DownloadDir12\\deviceList2.xlsx)