python excel实操之99乘法表

有两种实现方式：

代码：

from openpyxl import Workbook
from openpyxl.styles import Font, Border, Side, Alignment,PatternFill
from openpyxl.utils import get_column_letter

wb = Workbook()
ws = wb.active
num = 9
ws.column_dimensions[get_column_letter(1)].width = 5

for i in range(1, num+1):
    cell  = ws.cell(i+1, 1, i)
    cell.font = Font(bold=True)
    cell.fill = PatternFill(fill_type='solid', start_color="FFFF00")
    cell = ws.cell(1, i+1, i)
    cell.font = Font(bold=True)
    cell.fill = PatternFill(fill_type='solid', start_color="FFFF00")
    ws.column_dimensions[get_column_letter(i+1)].width = 5

for row in ws.iter_rows(min_row=2, max_row=i+1, min_col=2, max_col=i+1):
    for i in range(num):
        x = ws.cell(row[i].row, 1).value
        y = ws.cell(1, row[i].column).value
        ws.cell(row[i].row, row[i].column, x*y)
 
wb.save("乘法表.xlsx")

2.

代码：

#首先导入所需要的库

import os
import openpyxl

#新建一个工作簿
wb = openpyxl.Workbook()

#获得当前活动表
sheet = wb.active

#将当前活动表重命名
sheet.title = '99乘法表'

i = 0
j = 0
for i in range(1,10):
    for j in range(1, i+1):
        sheet.cell(row= i , column= j ).value = '{}*{}='.format(j,i) + str(i*j)

wb.save('99乘法表.xlsx')
wb.close()

相关阅读：

Python网页抓取- selenium用法及webelement对象操作实例

python excel实操之表格转置