制作荣誉证书试验记录

from pptx import Presentation
from openpyxl import load_workbook
path = r'D:\03其他资料\编程学习2023\ppt'
workbook = load_workbook(path + r'\name_excel.xlsx')   #文件名前面不要丢了反斜杠\
sheet = workbook.active

pptx = Presentation(path + r'\temp_ppt.pptx')
slide = pptx.slides.add_slide(pptx.slide_layouts[0])
for shape in slide.placeholders:
    shape.text = str(shape.placeholder_format.idx)
    #print(shape.text)

for row in sheet.rows:
    class_id = row[0].value
    name = row[1].value
    title = row[2].value
    #picture = row[3].value  #文字基本研究明白了，图片还没明白
    print(class_id,name,title)
    slide = pptx.slides.add_slide(pptx.slide_layouts[0])  #这一行保证循环11页
    slide.placeholders[0].text = f'{class_id}班{name}小朋友：'
    slide.placeholders[14].text = f'在2022年度获得{title}荣誉称号。'
    slide.placeholders[18].text = f'石家庄市幼儿园'
    #slide.placeholders[13].text = {picture} #文字基本研究明白了，图片还没明白
pptx.save(path + r'\result.pptx')