python excel实操之表格转置

效果如图：

代码：

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()