openpyxl对xlsx文件的读写操作
from openpyxl import load_workbook, Workbook写# 写一个新的xlsxwb_xlsx = Workbook()wb_xlsx.create_sheet(title='花名册',index=0)ws_xlsx = wb_xlsx.active# titlews_xlsx.append(['a', 'b', 'c', 'd', 'e', 'f'])for i in range(6): ws_xlsx.append([1,2,3,4,5,6])
原创
2022-02-25 16:21:13 ·
946 阅读 ·
0 评论