Python与excel数据写入

res=[['字段1','字段2'],[3,4],[5,6],[7,8],[9,10],[11,12],[13,14],[15,16],[17,18],[19,20],[21,22]]
#在没有文件的条件下创建文件并写入数据
def write_excel():
       book=xlwt.Workbook()
       sheet=book.add_sheet("第一个表")
       for row in range( 0,len(res)):
              for col in range(0,len(res[row])):
                     sheet.write(row,col,res[row][col])
              row+=1
       col+=1
       book.save('shujuwenjian.xls')  # 写入数据一次，再次使用的时候会报错
       print('save成功')
#在已经建立文件的条件下写入数据
def write_excel2():
       sheet=open('shujuwenjian.xls','w',encoding='gbk')
       sheet.write('字段1\t字段2\n')
       for row in range(len(res)):
              for col in range(len(res[row])):
                     sheet.write(str(res[row][col]))
                     sheet.write('\t')
              sheet.write('\n')
       sheet.close()
write_excel2()