import xlwt book = xlwt.Workbook() 先建一个book sheet = book.add_sheet(‘sheet1‘) 给book添加sheet页 sheet.write(0,0,‘id‘)#指定行和lie写内容 sheet.write(0,1,‘username‘) sheet.write(0,2,‘password‘)
第一种方式，利用循环嵌套写入数据
1 import xlwt 2 stus = [ 3 [1,‘njf‘,‘1234‘], 4 [2,‘xiaojun‘,‘1234‘], 5 [3,‘hailong‘,‘1234‘], 6 [4,‘xiaohei‘,‘1234‘], 7 ] 8 line = 0 #控制的是行 9 for stu in stus:#行 10 #stu [1,‘njf‘,‘1234‘] 11 col = 0 12 for s in stu: 13 sheet.write(line,col,s) 14 col+=1 15 line+=1 16 17 book.save(‘stu.xls‘)# .xlsx
第二种方式，利用枚举函数写入数据
import xlwt stus = [ [1,‘njf‘,‘1234‘], [2,‘xiaojun‘,‘1234‘], [3,‘hailong‘,‘1234‘], [4,‘xiaohei‘,‘1234‘], [4,‘xiaohei‘,‘1234‘], [4,‘xiaohei‘,‘1234‘], ] for row,stu in enumerate(stus): for col,s in enumerate(stu): sheet.write(row, col,s )
原文：https://www.cnblogs.com/gansd/p/10500124.html
