在這段代碼中,我從兩個列表中名為“電子郵件”的 Excel 工作表中導入了數據:一種。清單 1灣 列表2處理該數據并將該數據存儲在最后兩個列表中:一種。final_list1灣 final_list2現在我想將這兩個最終列表中的數據存儲在同一個 excel 中的新工作表中,但我無法做到這一點請幫助我打?。╢inal_list2)后代碼未運行import xlrdimport xlwtfile_location = "E:/emails.xlsx"workbook = xlrd.open_workbook(file_location)sheet = workbook.sheet_by_index(0)list1 = [sheet.cell_value(r,0) for r in range(sheet.nrows)]type(list1)for r in range(sheet.nrows): print(list1[r])final_list1 = [] for num in list1: if num not in final_list1: final_list1.append(num)print(final_list1)list2 = [sheet.cell_value(r,1) for r in range(sheet.nrows)]type(list2)for r in range(sheet.nrows): print(list2[r])final_list2 = [] for num in list2: if num not in final_list2: final_list2.append(num)print(final_list2)final_list2 = [elem for elem in final_list2 if elem not in final_list1 ]print(final_list2)book = xlwt.Workbook(encoding="utf-8")sh = book.add_sheet("sh")i=1for r in range(10): for col_index, item in enumerate(final_list2): sh.write(i, col_index, item) book.save("emails.xlsx")
添加回答
舉報
0/150
提交
取消