excel创建乘法表

主要是每个单元格的设置用sheet.cell[row= ,colum= ]来控制赋值

#! python3
# coding=utf-8
import openpyxl
wb=openpyxl.Workbook()
wb.create_sheet(index=0,title='multiplicationTable')
sheet=wb.get_sheet_by_name('multiplicationTable')

for col in range(2,11):
    for row in range(2,11):
        sheet.cell(row=row, column=1).value = row - 1
        sheet.cell(row=1, column=col).value = col - 1
        sheet.cell(row=row,column=col).value=sheet.cell(row=row,column=1).value*sheet.cell(row=1,column=col).value

wb.save('exce12.xlsx')