Python办公自动化保姆级教程⑤:PPT全自动生成实战,代码一键制作企业汇报、数据图表、图文幻灯片,告别手动排版

pip install python-pptx -i https://pypi.tuna.tsinghua.edu.cn/simple

from pptx import Presentationfrom pptx.util import Inches, Ptfrom pptx.enum.text import PP_ALIGNfrom pptx.dml.color import RGBColorfrom pptx.chart.data import CategoryChartDatafrom pptx.enum.chart import XL_CHART_TYPEimport openpyxl# ---------------------- 1. 数据准备 ----------------------def read_employee_data(file_path):    """从Excel读取员工数据"""    wb = openpyxl.load_workbook(file_path)    ws = wb["员工信息表"]    employees = []    departments = {}    for row in ws.iter_rows(min_row=2, values_only=True):        emp_id, name, dept, position, salary, hire_date, gender, age = row        employees.append({            "id": emp_id,            "name": name,            "dept": dept,            "position": position,            "salary": salary,            "hire_date": hire_date,            "gender": gender,            "age": age        })        # 统计部门人数        if dept in departments:            departments[dept] += 1        else:            departments[dept] = 1    return employees, departments# 读取数据employees, departments = read_employee_data("data.xlsx")total_employees = len(employees)avg_age = sum(emp["age"] for emp in employees) / total_employeesavg_salary = sum(emp["salary"] for emp in employees) / total_employees# ---------------------- 2. PPT生成 ----------------------# 创建PPT对象prs = Presentation()# ========== 封面页 ==========slide_layout = prs.slide_layouts[0]slide = prs.slides.add_slide(slide_layout)title = slide.shapes.titlesubtitle = slide.placeholders[1]title.text = "员工分析报告"subtitle.text = f"报告日期：2026年8月\n总员工数：{total_employees}人"# 设置标题样式title.text_frame.paragraphs[0].font.size = Pt(48)title.text_frame.paragraphs[0].font.bold = Truetitle.text_frame.paragraphs[0].font.color.rgb = RGBColor(255, 102, 0) # 橙色# ========== 总体概览页 ==========slide_layout = prs.slide_layouts[1]slide = prs.slides.add_slide(slide_layout)title_shape = slide.shapes.titlebody_shape = slide.placeholders[1]title_shape.text = "公司员工总体概览"tf = body_shape.text_frametf.text = "核心指标："p = tf.add_paragraph()p.text = f"• 员工总数：{total_employees} 人"p.level = 1p = tf.add_paragraph()p.text = f"• 平均年龄：{avg_age:.1f} 岁"p.level = 1p = tf.add_paragraph()p.text = f"• 平均薪资：{avg_salary:,.0f} 元"p.level = 1# ========== 部门分布图表页 ==========slide_layout = prs.slide_layouts[5] # 空白页布局，方便自由放置元素slide = prs.slides.add_slide(slide_layout)# 添加标题left = Inches(0.5)top = Inches(0.5)width = Inches(9)height = Inches(1)title_box = slide.shapes.add_textbox(left, top, width, height)title_frame = title_box.text_frametitle_paragraph = title_frame.add_paragraph()title_paragraph.text = "各部门员工分布"title_paragraph.font.size = Pt(24)title_paragraph.font.bold = True# 创建柱状图数据chart_data = CategoryChartData()chart_data.categories = list(departments.keys())chart_data.add_series('员工人数', list(departments.values()))# 添加图表到幻灯片left = Inches(1)top = Inches(1.5)width = Inches(8)height = Inches(5)slide.shapes.add_chart(    XL_CHART_TYPE.COLUMN_CLUSTERED,    left, top, width, height,    chart_data)# ========== 员工列表页 ==========slide_layout = prs.slide_layouts[1]slide = prs.slides.add_slide(slide_layout)title_shape = slide.shapes.titlebody_shape = slide.placeholders[1]title_shape.text = "员工信息列表（前5名）"tf = body_shape.text_frametf.text = "ID | 姓名 | 部门 | 职位 | 薪资"for emp in employees[:5]: # 只显示前5条    p = tf.add_paragraph()    p.text = f"{emp['id']} | {emp['name']} | {emp['dept']} | {emp['position']} | {emp['salary']:,}"    p.level = 1# ========== 保存PPT ==========prs.save("员工分析报告.pptx")print("员工分析报告PPT生成成功！")