乘法表

import openpyxl
from openpyxl.styles import Font

wb = openpyxl.Workbook()
sheet = wb.get_active_sheet()

font = Font(size=20,bold=True)  # 粗体

# 生成乘法表
num = int(input('请输入最大数字：'))
nums_row = list(range(1, num+1))
nums_column = list(range(1, num+1))
nums_result = []

for num_row in nums_row:
    def f(x):
        return num_row * x
    nums_result.append(list(map(f, nums_column)))  # map(f(), nums_column)报错

#  设置表头格式，添加表头内容
for i in range(2, num+2):
    sheet.cell(row=1, column=i).font = font
    sheet.cell(row=1, column=i).value = nums_column[i-2]
    sheet.cell(row=i, column=1).font = font
    sheet.cell(row=i, column=1).value = nums_column[i-2]

# 填充乘法表
for i in range(2, num+2):
    for j in range(2, num+2):
        sheet.cell(row=i, column=j).value = nums_result[i-2][j-2]

# 保存xlsx
wb.save('multi_plication_table.xlsx')