Python操作excle表-九九乘法表

from openpyxl import Workbook

wb = Workbook()
ws = wb.get_active_sheet()
ws.title='99表'
for row in range(1,10):
    for col in range(1,10):
        ws.cell(row = row, column = col).value = row * col
wb.save(filename = 'xxx.xlsx')

 

posted @ 2017-05-12 12:38  RonyJay  阅读(433)  评论(0编辑  收藏  举报