数据存入已有Excel

import openpyxl

filepath = r'.\UCB2Create_course\SuccsessCourse.xlsx'

wb = openpyxl.load_workbook(filepath)

sheetnames = wb.sheetnames


ws = wb['Sheet']

data = [[1,2,3],[4,5,6]]

for x in data:
    ws.append(x)



savename = r'.\UCB2Create_course\SuccsessCourse.xlsx'
wb.save(savename)
posted @ 2021-08-18 21:00  乐乐乐乐乐乐樂  阅读(36)  评论(0)    收藏  举报
jQuery火箭图标返回顶部代码