Python小工具提升工作效率【附完整版，可下载word】

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("    ")

#提取计划

#for i in range(1,33):

#    file.add_paragraph(sheet.cell(row=i,column=2).value)