在这段代码中,我从名为“emails”的excel表中导入了两个列表中的数据:
a.列表1
b.列表2
处理这些数据并将其存储在最后两个列表中:
a.最终清单1
b.最终清单2
现在我想将这两个最终列表中的数据存储在同一个excel中,我不能这样做请帮助我
打印后代码未运行(最终列表2)import xlrd
import xlwt
file_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