将二维列表输出到excel

list1 = [['张三','男','未婚',20],['李四','男','已婚',28],['小红','女','未婚',18],['小芳','女','已婚',25]]
output = open('data.txt','w',encoding='gbk')
output.write('name,gender,status,age\n')
for row in list1:
    rowtxt = '{},{},{},{}'.format(row[0],row[1],row[2],row[3])
    output.write(rowtxt)
    output.write('\n')
output.close()

实操

output = open('resultData.xls', 'w', encoding='gbk')
print(labeldict)
print("\t".join(labeldict)+"\n")
output.write("address\t"+"preds\t"+"\t".join(labeldict)+"\n")
for i in range(len(result)):
	for j in range(len(result[i])):
		output.write(str(result[i][j]))  # write函数不能写int类型的参数，所以使用str()转化
        output.write('\t')  # 相当于Tab一下，换一个单元格
    output.write('\n')  # 写完一行立马换行
output.close()