为什么Sheet2中没有内容,哪位大神帮忙看看


from openpyxl import load_workbook#打开工作簿information_wb = load_workbook('C:/Users/Administrator/Desktop/公务员招考.xlsx')active_ws = information_wb['Sheet1']new_ws = information_wb['Sheet2']other_ws = information_wb['Sheet3']for row1 in active_ws.iter_rows(min_row=2,values_only=True): new_ws.append(row1)late_header = ['USN','AAF','USN']other_ws.append(late_header)for row3 in active_ws.iter_rows(min_row=2,values_only=True): USN = row3[4] KEY_TYPE = row3[11] if USN == ['省级','昆明市'] and KEY_TYPE =='1': AAF = row3[5] other_ws.append(AAF)information_wb.save('C:/Users/Administrator/Desktop/公务员招考.xlsx')