[Python知识库]Python编程快速上手 13.14.1 乘法表

Mac代码，windows未知

import sys, openpyxl

from openpyxl.utils import get_column_letter, column_index_from_string

from openpyxl.styles import Font

wb = openpyxl.Workbook()

sheet = wb.active

sheet.title = 'Num'

for i in range(1, int(sys.argv[1]) + 1):

for j in range(1, int(sys.argv[1]) + 1):

fontObj = Font(bold = True)

sheet['A' + str(i + 1)] = i

sheet['A' + str(i + 1)].font = fontObj

sheet[str(get_column_letter(i + 1)) + str(1)] = i

sheet[str(get_column_letter(i + 1)) + str(1)].font = fontObj

sheet.cell(row=(j+1), column=(i+1)).value = (j*i)

wb.save('chengfangTemple.xlsx')

打开终端，输入“python3空格这个代码的名字.py空格乘法表的最大数字”? 回车，在/users/你的用户名下找到‘chengfangTemple.xlsx'