# 讀取圖片文件
import os
# 讀取Excel數(shù)據(jù)
import pandas as pd
# 操作PPT
from pptx import Presentation

#讀取電影數(shù)據(jù)
df = pd.read_excel(r".\ppt素材\top250.xlsx")
data = df.to_dict('records')
print(data)

# 讀取母版文件構建PPT的對象
my_ppt = Presentation(r".\ppt素材\ppt模板.pptx")
# 獲取母版所有幻燈片布局
layout = my_ppt.slide_layouts
# 遍歷所有電影數(shù)據(jù)
for x in data:
    #print(x)
    #選擇模板中第一個幻燈片的布局并創(chuàng)建新幻燈片
    slide = my_ppt.slides.add_slide(layout[0])
    #當前幻燈片中所有的占位符
    placeholders = slide.shapes.placeholders
    for i,pl in enumerate(placeholders):
        if i == 0:
            pl.text = x["title"]
        elif i == 2:
            pl.text = x["types"]
        elif i == 3:
            pl.text = x["director"]
        elif i == 4:
            pl.text = str(x["date"])
        elif i == 5:
            pl.text = x["country"]
my_ppt.save("result.pptx")

# 電影海報存儲路徑
images = r".\ppt素材\movie_pic"

# 遍歷所有電影數(shù)據(jù)
for x in data:
    slide = my_ppt.slides.add_slide(layout[0])
    placeholders = slide.shapes.placeholders
    for i,pl in enumerate(placeholders):
        if i == 0:
            pl.text = x["title"]
        elif i == 1:
            img_path = os.path.join(images,f'{x["title"]}.jpg')
            print(img_path)
            pl.insert_picture(img_path)