book = xlwt.Workbook(encoding='utf-8', style_compression=0)
sheet = book.add_sheet('Total_Words', cell_overwrite_ok=True)
colnew = sorted(L, key=lambda x: (x[1]), reverse=True)
for i in range(len(colnew)):
# sheet.write(0, i, str(colnew[i]))
data = colnew[i]
if data == 0:
continue
else:
for j in range(0, 2):
sheet.write(i + 1, j, data[j])
savepath = 'D:/excel表格2.xls'
book.save(savepath)
len(colnew)先赋值在代入
book = xlwt.Workbook(encoding='utf-8', style_compression=0)
sheet = book.add_sheet('Total_Words', cell_overwrite_ok=True)
colnew = sorted(L, key=lambda x: (x[1]), reverse=True)
lent = len(colnew)
for i in range(lent):
# sheet.write(0, i, str(colnew[i]))
data = colnew[i]
if data == 0:
continue
else:
for j in range(0, 2):
sheet.write(i + 1, j, data[j])
savepath = 'D:/excel表格2.xls'
book.save(savepath)