数据存入已有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)

数据存入已有Excel

原文：https://www.cnblogs.com/djl-0628/p/15158801.html