import xlwt#寫excel用的是xlwt模塊

http://www.nnzhp.cn/archives/142 #博客目錄

book=xlwt.Workbook()#新建一個excel
sheet=book.add_sheet('sheet1')#添加一個sheet頁

print(dir(sheet))#查看sheet有啥方法

sheet.write(0,0,'姓名')

sheet.write(0,1,'性別')

sheet.write(0,2,'年齡')

book.save('stu.xls')# 微軟的office不能用xlsx結尾的，wps隨意

stus = [
[ '姓名','年齡','性別','分數(shù)'],
['mary', 20, '女', 89.9],
['lucy', 50, '女', 100],
['CiCi', 10, '女', 89.9],
['Tom', 25, '男', 88]]
rows=0# 控制行
for stu in stus:
new_colums = 0; # 控制列
for s in stu:
sheet.write(rows,new_colums,s)
new_colums=new_colums+1
rows=rows+1
book.save('new_stu1.xls')