Excel-乘法表

@(Python)[python]

乘法表

创建程序multiplicationTable.py，从命令行接受数字N，在一个Excel 电子表格中创建一个N×N 的乘法表。例如，如果这样执行程序：
py multiplicationTable.py 6
它应该创建一个图所示的电子表格。

行1 和列A 应该用做标签，应该使用粗体。

from trace import Traceimport openpyxlimport sysfrom openpyxl.styles import Font# script first argumentmax_num = int(sys.argv[1])# init excel infowb = openpyxl.Workbook()sheet = wb.get_active_sheet()sheet.title = 'multiplicationTable'font = Font(bold=True)# init first row...1 2 3 4 ...for column in range(1, max_num + 1):    multiplier_cell = sheet.cell(row=1, column=column + 1)    multiplier_cell.font = font    multiplier_cell.value = column# init first column...1 2 3 4 ...for row in range(1, max_num + 1):    multiplicand_cell = sheet.cell(row=row + 1, column=1)    multiplicand_cell.font = font    multiplicand_cell.value = row# Solve-by dynamic programmingfor row in range(1, max_num + 1):    for column in range(1, max_num + 1):        # each column, first row        multiplier_cell = sheet.cell(row=1, column=column + 1)        # each row, first column        multiplicand_cell = sheet.cell(row=row + 1, column=1)        # result[i][j] = result[1][i] * result[i][1]        result_cell = sheet.cell(row=row + 1, column=column + 1)        multiplier_value = multiplier_cell.value        multiplicand_value = multiplicand_cell.value        result_cell.value = multiplier_value * multiplicand_valuewb.save('multiplicationTable.xlsx')