1、多个ppt汇总成一个ppt的python代码实现:
import win32com.client as win32
import os
import re
def find(s):
pat = re.compile(r"\d+")
result = pat.match(s)
return int(result.group(0))
def join_ppt(path:str):
"""
:param path: ppt所在文件路径
:return: None
"""
files = os.listdir(path)
files.sort(key = find)
Application = win32.gencache.EnsureDispatch("PowerPoint.Application")
# Application.Visible = False
new_ppt = Application.Presentations.Add()
for file in files:
abs_path = os.path.join(path, file)
exit_ppt = Application.Presentations.Open(abs_path)
print(abs_path)
page_num = exit_ppt.Slides.Count
exit_ppt.Close()
new_ppt.Slides.InsertFromFile(abs_path, new_ppt.Slides.Count, 1, page_num)
new_ppt.Save() # 保存在C:\Users\Administrator\Documents\下
Application.Quit()
join_ppt(r"C:\Users\Administrator\Desktop\makeyourownneuralnetwork-master\ppt")
2、实现execl表自动转为word文档的python代码实现
#execl表转word
import openpyxl
import docx
file=docx.Document()
wb=openpyxl.load_workbook('C:\\Users\\Administrator\\Desktop\\zhihui.xlsx')
sheet = wb.active
sheet.title
#sheet.cell(row=5,column=2).value
#提取总结
for i in range(1,33):
#print (i,sheet.cell(row=i,column=2).value)
file.add_paragraph(sheet.cell(row=i,column=2).value)
file.add_paragraph(sheet.cell(row=i,column=13).value)
file.add_paragraph(sheet.cell(row=i,column=14).value)
file.add_paragraph(" ")<