一站式网上办事大厅

from pptx import Presentation

def generate_report(data):

# 加载现有的PPTX模板

prs = Presentation("template.pptx")

# 遍历幻灯片并替换占位符

for slide in prs.slides:

for shape in slide.shapes:

if shape.has_text_frame:

text_frame = shape.text_frame

for paragraph in text_frame.paragraphs:

for run in paragraph.runs:

if "【姓名】" in run.text:

run.text = run.text.replace("【姓名】", data["name"])

elif "【学号】" in run.text:

run.text = run.text.replace("【学号】", str(data["student_id"]))

# 保存新生成的PPTX文件

prs.save("output.pptx")

# 示例数据

data = {

"name": "张三",

"student_id": 20210001

}

generate_report(data)

]]>

import pandas as pd

df = pd.read_excel("students.xlsx")

智慧学工管理系统

for index, row in df.iterrows():

data = {

"name": row["姓名"],

"student_id": row["学号"]

}

generate_report(data)

]]>