通过python将图表从excel复制到powerpoint。

pip install openpyxl
pip install python-pptx

from openpyxl import load_workbook
from pptx import Presentation
from pptx.util import Inches

excel_file = "path/to/excel/file.xlsx"
wb = load_workbook(excel_file)
sheet = wb["Sheet1"]
chart_data = sheet["A1:E5"]

ppt = Presentation()
slide = ppt.slides.add_slide(ppt.slide_layouts[1])  # 使用第二种幻灯片布局

left = Inches(1)  # 图表左上角的横坐标
top = Inches(1)  # 图表左上角的纵坐标
width = Inches(6)  # 图表的宽度
height = Inches(4)  # 图表的高度

chart = slide.shapes.add_chart(
    chart_type=XL_CHART_TYPE.LINE,  # 图表类型，可以根据需求更改
    left=left,
    top=top,
    width=width,
    height=height,
).chart

chart_data = chart_data.transpose()  # 转置图表数据
chart.categories = chart_data[0]  # 设置图表的横坐标
for i in range(1, len(chart_data)):
    chart.add_series(chart_data[i], chart_data[0])  # 添加图表系列数据

ppt.save("path/to/powerpoint/file.pptx")