book = xlwt.Workbook() sheet = book.add_sheet("sheet1") title = ["id","name","sex","city"] students = [ [1,"a","男","北京"], [2,"b,"男","北京"], [3,"c","女","深圳"], [4,"d","女","北京"], ] students.insert(0,title) for row,student in enumerate(students): for col,value in enumerate(student): sheet.write(row,col,value) book.save("test.xls")