python利用xlst包将九九乘法表写入Excel表中

最新推荐文章于 2024-01-26 10:12:37 发布

ServletFS

最新推荐文章于 2024-01-26 10:12:37 发布

阅读量769

点赞数 1

文章标签： python

本文链接：https://blog.youkuaiyun.com/qq_42700192/article/details/106534646

版权

#-*- codeing = utf-8 -*-
#@Time : 2020/6/3 22:25
#@Author : JACHK
#@File : chengfabiao.py
#@Software : PyCharm
import xlwt

workbook = xlwt.Workbook(encoding = "utf-8")
worksheet = workbook.add_sheet("chengfabiao")

worksheet.write(0,0,"乘法表")
for i in range(1,10):
    for j in range(1,10):
        result = i * j
        worksheet.write(i,j,result)

workbook.save("chengfabiao.xls")

版本2：

 #-*- codeing = utf-8 -*-
#@Time : 2020/6/3 22:25
#@Author : JACHK
#@File : chengfabiao.py
#@Software : PyCharm
import xlwt

workbook = xlwt.Workbook(encoding = "utf-8")
worksheet = workbook.add_sheet("chengfabiao")

worksheet.write(0,0,"乘法表")
for i in range(1,10):
    for j in range(1,i + 1):
        worksheet.write(i,j,"%d × %d = %d"%(i, j,i*j))

workbook.save("chengfabiao.xls")