爬虫之xlwt

import xlwt
'''
workbook = xlwt.Workbook(encoding="utf-8") #创建workbook对象
worksheet = workbook.add_sheet('sheet1') #创建工作表
worksheet.write(0,0,'hello') #写入数据,第一行参数“行”,第二行参数“列”,第三行参数写入内容
workbook.save('student.xls') #保存数据表
'''
workbook = xlwt.Workbook(encoding="utf-8") #创建workbook对象
worksheet = workbook.add_sheet('sheet1') #创建工作表
for i in range(0,9):
for j in range(0,i+1):
worksheet.write(i,j,'%d * %d = %d'%(i+1,j+1,(i+1*j+1)))


workbook.save('student.xls') #保存数据表
posted @ 2020-06-08 20:45  Eliphaz  阅读(197)  评论(0编辑  收藏  举报