fromopenpyxlimportWorkbookwb=Workbook()ws=wb.active'''指定sheetwb.create_sheet("mySheet")ws=wb.get_sheet_by_name("mySheet")'''i=1j=1forvalinheaders:ws.cell(row=i,column=j,value=val)j=j+1i=2forrowindata_lines:j=1forvalinrow:ws.cell(row=i,column=j,value=val)j=j+1i=i+1###冻结窗口，单元格上面的行和左边的列将会冻结(单元格所在的行和列不会被冻结)#冻结第一行ws.freeze_panes=ws['A2']#冻结第一列ws.freeze_panes=ws['B1']#冻结第一行第一列ws.freeze_panes=ws['B2']wb.save(expfile)