效果如图:
![](https://i-blog.csdnimg.cn/blog_migrate/7ea3a4b8891a999c8abf8b046b237a55.png)
代码:
wb = Workbook()
ws = wb.active
ws.title = '99乘法表'
i = 0
j = 0
for i in range(1,10):
for j in range(1, i+1):
ws.cell(row= i, column=j ).value = '{}*{}='.format(j,i) + str(i*j)
# 转置
delta = 11
for row in range(1, ws.max_row + 1):
for col in range(1, row + 1):
ws.cell(row=col+delta, column=row).value = ws.cell(row=row, column=col).value
wb.save('99乘法表.xlsx')
wb.close()