通过Python更新PowerPoint中的链接excel路径

pip install openpyxl
pip install python-pptx

from pptx import Presentation
from openpyxl import load_workbook

ppt = Presentation('presentation.pptx')
wb = load_workbook('data.xlsx')

for slide in ppt.slides:
    for shape in slide.shapes:
        if shape.has_text_frame:
            for paragraph in shape.text_frame.paragraphs:
                for run in paragraph.runs:
                    if run.hyperlink is not None:
                        old_link = run.hyperlink.address
                        new_link = wb['Sheet1']['A1'].value  # 假设新链接路径在Excel的A1单元格中
                        run.hyperlink.address = new_link

ppt.save('updated_presentation.pptx')