from openpyxl.workbook import Workbook
from openpyxl.styles import Font
import sys
import os
os.chdir('.')#记得改变当前工作目录至目的地不然找不到文件
n =int(sys.argv[1])
wb = Workbook()
ws = wb.active
ws.freeze_panes ='B2'#冻结窗口
f = Font(bold=True)#将第一行和第一列数字填入并设置格式for i inrange(1,n+1):
ws.cell(row=1,column=i+1).value = i
ws.cell(row=i+1,column=1).value = i
ws.cell(row=1,column=i+1).font = f
ws.cell(row=i+1,column=1).font = f
#遍历剩下单元格将选取对应的数字相乘得到的结果填入for row in ws.iter_rows(min_row=2, min_col=2, max_row=n+1,max_col=n+1):for cell in row:
cell.value =int(ws.cell(row=1,column=cell.column).value)\
*int(ws['A'+str(cell