创建程序multiplicationTable.py,从命令行接受数字N,在一个Excel电子表格中创建一个N×N的乘法表。
import openpyxl
import openpyxl.styles
import openpyxl.utils
import sys
wb = openpyxl.Workbook()
sheet = wb.create_sheet()
tablesize = int(sys.argv[-1])
boldFont = openpyxl.styles.Font(bold=True)
for x in range(1,(tablesize+1)+1):
for y in range(1,(tablesize+1)+1):
cell = sheet.cell(row=x,column=y)
if x==1 and y==1:
cell.value = ""
elif y==1:
cell.value = x-1
cell.font = boldFont
elif x==1:
cell.value = y-1
cell.font = boldFont
else:
cell.value = sheet.cell(row=1,column=y).value*sheet.cell(row=x,column=1).value
wb.save("multiplicationTable.xlsx")