Python批量生成PPT

import os

import win32com.client

import matplotlib.pyplot as plt

ppt_app = win32com.client.Dispatch("KWPP.Application")

ppt_app.Visible = True

presentation = ppt_app.Presentations.Add()

et_app = win32com.client.Dispatch("Ket.Application")

wb = et_app.Workbooks.Open(os.getcwd() + '\\a.xlsx')

slide_1 = presentation.Slides.Add(1, 12)

sht = wb.Sheets(1)

sht.Activate()

chart = wb.Charts.Add()

chart.ChartType = 51

chart.SetSourceData(sht.Range("A:A"))

chart.CopyPicture()

slide_1.Shapes.PasteSpecial()

slide_2 = presentation.Slides.Add(2, 12)

fig, ax = plt.subplots()

ax.axis('off')

formula = r'$e^{i\pi}+\sqrt{\sin(\frac{\pi}{2})}=0$'

text_obj = ax.text(0, 0, formula, fontsize=20, ha='left', va='bottom')

bbox = text_obj.get_window_extent()

fig.set_size_inches(bbox.width/fig.dpi, bbox.height/fig.dpi)

f = os.getcwd() + '\\a.png'

fig.savefig(f, bbox_inches='tight', pad_inches=0)

slide_2.Shapes.AddPicture(f, False, True, 100, 100)

wb.Close(False)

et_app.Quit()