python写入excel

import openpyxl

book = openpyxl.Workbook()
sh = book.active

sh.title = '工资表'

sh1 = book.create_sheet('年龄表-最后')
sh2 = book.create_sheet('年龄表-最后后')
sh3 = book.create_sheet('年龄表-最前',0)
sh4 = book.create_sheet('年龄表-第二',1)

sh['A1'] = '你好'
print(sh['A1'].value)

sh.cell(2, 2, value = '他好')
print(sh.cell(2,2).value)

sh.cell(3,3).value = '我好'
print(sh.cell(3,3).value)

book.save('/Users/xmtxmt/tmp/ex02.xlsx')
posted @ 2021-10-04 16:47  佳佳不是熊猫  阅读(45)  评论(0)    收藏  举报