创建一个.xls的文件到本地（Excel表，注意同scrapy中的区别）

通过代码创建一个.xls的文件到本地，并写入多条数据，比如姓名，年龄，身高，体重等

import xlwt

book = xlwt.Workbook()

sheet = book.add_sheet('stu')

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

sheet.write(0, 1, '年龄')

sheet.write(0, 2, '身高')

sheet.write(0, 3, '体重')

 

list1 = [('zhangsan','20','180','80'), ('lisi','30','170','60')]

row = 1

for name, age, height, weight in list1:

sheet.write(row, 0, name)

sheet.write(row, 1, age)

sheet.write(row, 2, height)

sheet.write(row, 3, weight)

row += 1

 

book.save('stu.xls')