python根据excel自动生成ppt代码

最新推荐文章于 2024-02-15 09:49:05 发布
最新推荐文章于 2024-02-15 09:49:05 发布
阅读量1.1k 收藏 7
点赞数
分类专栏： python 文章标签： 其他
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_36593769/article/details/111568569
版权

系统环境

  1. 系统：window
  2. 环境：
  • python 3.7
  • pip
  • pptx
  • openpyxl
  1. 开发工具

引入需要的包

pip install openpyxl

pip install python-pptx

pip install jupyter

配置config.ini文件

[base]
basePPTpath = E:\anna\base\base-2.pptx
baseExcelPath = E:\anna\LEP#185会议议程.xlsx
targetPPTpath =E:\anna\base\LEP#185会议议程.pptx
sheetName =会议议程前页
voting=E:\anna\base\VOTING.png
backGrounBase=E:\anna\base\backgroud.png
backGroundQR=E:\anna\base\QR_CODE_BACKGROUND.png

准备文件

在这里插入图片描述
代码

import pptx
import openpyxl
import time
import  os
import math
from pptx import Presentation
from openpyxl import load_workbook
from pptx.util import Inches, Pt, Cm
from pptx.dml.color import RGBColor
from pptx.enum.text import PP_PARAGRAPH_ALIGNMENT,MSO_AUTO_SIZE
from pptx.enum.shapes import MSO_AUTO_SHAPE_TYPE
from pptx.enum.dml import MSO_FILL_TYPE
from configparser import ConfigParser
import os
import copy
import numpy as np
import datetime, calendar
import queue


def getCurrentFriday():
    lastFriday = datetime.date.today()
    oneday = datetime.timedelta(days=1)
    while lastFriday.weekday() != calendar.FRIDAY:
        lastFriday += oneday
    return str(lastFriday.strftime("%Y.%m.%d"))

def addTimeRule(prs):
    copied_slide = prs.slides[15]
    workbook = load_workbook(filename=baseExcelPath)
    sheet = workbook["会议议程后页"]
    for j, shape in enumerate(copied_slide.shapes):
        if shape.has_table:
            shape.table.cell(0,0).text = "Type of Speech"
            shape.table.cell(0,0).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(0,0).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(0,0).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(0, 0).text_frame.paragraphs[0].font.color.rgb = RGBColor(0, 0, 0)
            shape.table.cell(1, 0).text = sheet.cell(row=30, column=1).value
            shape.table.cell(1, 0).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(1, 0).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(1,0).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(2, 0).text = sheet.cell(row=31, column=1).value
            shape.table.cell(2, 0).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(2, 0).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(2,0).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(3, 0).text = sheet.cell(row=32, column=1).value
            shape.table.cell(3, 0).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(3, 0).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(3,0).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(4, 0).text = sheet.cell(row=33, column=1).value
            shape.table.cell(4, 0).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(4, 0).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(4,0).text_frame.paragraphs[0].font.size = Pt(20)

            shape.table.cell(0, 1).text = sheet.cell(row=29, column=11).value
            shape.table.cell(0, 1).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(0, 1).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(0, 1).text_frame.paragraphs[0].font.color.rgb = RGBColor(0, 0, 0)
            shape.table.cell(0,1).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(1, 1).text = sheet.cell(row=30, column=11).value
            shape.table.cell(1, 1).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(1,1).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(2, 1).text = sheet.cell(row=31, column=11).value
            shape.table.cell(2, 1).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(2,1).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(3, 1).text = sheet.cell(row=32, column=11).value
            shape.table.cell(3, 1).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(3,1).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(4, 1).text = sheet.cell(row=33, column=11).value
            shape.table.cell(4, 1).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(4,1).text_frame.paragraphs[0].font.size = Pt(20)

            shape.table.cell(0, 2).text = sheet.cell(row=29, column=17).value
            shape.table.cell(0, 2).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(0, 2).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(0, 2).text_frame.paragraphs[0].font.color.rgb = RGBColor(0, 0, 0)
            shape.table.cell(0,2).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(1, 2).text = sheet.cell(row=30, column=17).value
            shape.table.cell(1, 2).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(1,2).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(2, 2).text = sheet.cell(row=31, column=17).value
            shape.table.cell(2, 2).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(2,2).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(3, 2).text = sheet.cell(row=32, column=17).value
            shape.table.cell(3, 2).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(3,2).text_frame.paragraphs[0].font.size = Pt(20)

            shape.table.cell(0, 3).text = sheet.cell(row=29, column=23).value
            shape.table.cell(0, 3).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(0, 3).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(0, 3).text_frame.paragraphs[0].font.color.rgb = RGBColor(0, 0, 0)
            shape.table.cell(0,3).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(1, 3).text = sheet.cell(row=30, column=23).value
            shape.table.cell(1, 3).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(1,3).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(3, 3).text = sheet.cell(row=32, column=23).value
            shape.table.cell(3, 3).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(3,3).text_frame.paragraphs[0].font.size = Pt(20)

            shape.table.cell(0, 4).text = sheet.cell(row=29, column=28).value
            shape.table.cell(0, 4).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(0, 4).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(0, 4).text_frame.paragraphs[0].font.color.rgb = RGBColor(0, 0, 0)
            shape.table.cell(0,4).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(1, 4).text = sheet.cell(row=30, column=28).value
            shape.table.cell(1, 4).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(1,4).text_frame.paragraphs[0].font.size = Pt(20)

            shape.table.cell(0, 5).text = sheet.cell(row=29, column=34).value
            shape.table.cell(0, 5).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(0, 5).text_frame.paragraphs[0].font.bold = True
            shape.table.cell(0, 5).text_frame.paragraphs[0].font.color.rgb = RGBColor(0, 0, 0)
            shape.table.cell(0,5).text_frame.paragraphs[0].font.size = Pt(20)
            shape.table.cell(1, 5).text = sheet.cell(row=30, column=34).value
            shape.table.cell(1, 5).text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
            shape.table.cell(1,5).text_frame.paragraphs[0].font.size = Pt(20)
    copied_slide.shapes[2].text_frame.text="Shanghai L.E.P. Bilingual Toastmasters Club #185 | "+getCurrentFriday()
    copied_slide.shapes[2].text_frame.paragraphs[0].font.size = Pt(18)
    copied_slide.shapes[2].text_frame.paragraphs[0].font.color.rgb = RGBColor(242, 242, 242)
    copied_slide.shapes[2].text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.RIGHT


def duplicate_slide(pres,index):
    slide = pres.slides[index]
    blank_slide_layout = pres.slide_layouts[6] #空白页
    copied_slide = pres.slides.add_slide(blank_slide_layout)
    for shape in slide.shapes:
        el = shape.element
        newel = copy.deepcopy(el)
        copied_slide.shapes._spTree.insert_element_before(newel, 'p:extLst')
    for value in slide.part.rels.values():
        # Make sure we don't copy a notesSlide relation as that won't exist
        if "notesSlide" not in value.reltype:
            copied_slide.part.rels.add_relationship(value.reltype,value._target, value.rId)
    arrayList=np.array([0,1,2,3,4,5,6])
    # clear_shape(copied_slide,arrayList)
    return copied_slide
def addTopic(copied_slide,topic,topOrBottom):
    if(topOrBottom=="top"):
        topic_shape = copied_slide.shapes.add_shape(MSO_AUTO_SHAPE_TYPE.RECTANGLE, Cm(0.81), Cm(11.71), Cm(32.25), Cm(2.03))
    elif(topOrBottom=="bottom"):
        topic_shape = copied_slide.shapes.add_shape(MSO_AUTO_SHAPE_TYPE.RECTANGLE, Cm(0.04), Cm(9.72), Cm(33.79), Cm(2.03))
    else:
        raise Exception('log position Error')
    topic_shape.text_frame.text=topic
    # topic_shape.text_frame.auto_size=MSO_AUTO_SIZE.TEXT_TO_FIT_SHAPE
    topic_shape.fill.background()
    topic_shape.line.fill.background()
    topic_shape.text_frame.margin_bottom=Cm(0.13)
    topic_shape.text_frame.margin_top=Cm(0.13)
    topic_shape.text_frame.margin_left = Cm(0.25)
    topic_shape.text_frame.margin_right = Cm(0.25)
    para = topic_shape.text_frame.paragraphs[0]
    para.alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
    font = para.font
    font.size = Pt(72)
    font.name = 'Arial'
    font.bold = True
    font.color.rgb = RGBColor(254, 238, 159)

def addLogandTime(copied_slide,topOrBottom):

    if(topOrBottom=="top"):
        topic_shape = copied_slide.shapes.add_shape(MSO_AUTO_SHAPE_TYPE.RECTANGLE, Cm(4.23), Cm(0.90), Cm(25.40), Cm(2.54))
        topic_shape.text_frame.text ="Shanghai L.E.P. Bilingual Toastmasters Club #185 | " + getCurrentFriday()
        # topic_shape.text_frame.auto_size=MSO_AUTO_SIZE.TEXT_TO_FIT_SHAPE
        topic_shape.fill.background()
        topic_shape.line.fill.background()
        topic_shape.text_frame.margin_bottom = Cm(0.13)
        topic_shape.text_frame.margin_top = Cm(0.13)
        topic_shape.text_frame.margin_left = Cm(0.25)
        topic_shape.text_frame.margin_right = Cm(0.25)
        para = topic_shape.text_frame.paragraphs[0]
        para.alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
        font = para.font
        font.size = Pt(24)
        font.name = 'Arial'
        font.bold = False
        font.color.rgb = RGBColor(255, 255, 255)
    elif(topOrBottom=="bottom"):
        topic_shape = copied_slide.shapes.add_shape(MSO_AUTO_SHAPE_TYPE.RECTANGLE, Cm(4.23), Cm(16.15), Cm(25.40), Cm(2.54))
        topic_shape.text_frame.text = "Shanghai L.E.P. Bilingual Toastmasters Club #185"
        p=topic_shape.text_frame.add_paragraph()
        p.text = getCurrentFriday()
        topic_shape.fill.background()
        topic_shape.line.fill.background()
        topic_shape.text_frame.margin_bottom = Cm(0.13)
        topic_shape.text_frame.margin_top = Cm(0.13)
        topic_shape.text_frame.margin_left = Cm(0.25)
        topic_shape.text_frame.margin_right = Cm(0.25)
        para = topic_shape.text_frame.paragraphs[0]
        para.alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
        font = para.font
        font.size = Pt(24)
        font.name = 'Arial'
        font.bold = False
        font.color.rgb = RGBColor(255, 255, 255)
        para = topic_shape.text_frame.paragraphs[1]
        para.alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
        font = para.font
        font.size = Pt(24)
        font.name = 'Arial'
        font.bold = False
        font.color.rgb = RGBColor(255, 255, 255)
    else:
        raise Exception('log position Error')
def addtopicKey(copied_slide,topicKey,referee):
    if(referee==None):
        textbox = copied_slide.shapes.add_textbox(Cm(3.75),
                                                  Cm(8.28),
                                                  Cm(30.11),
                                                  Cm(2.03)
                                                  )
        tf = textbox.text_frame
        para = tf.paragraphs[0]
        para.text = topicKey
        # 设置字体属性
        font = para.font
        font.size = Pt(20)  # 大小
        font.name = 'Arial'  # 字体
        font.bold = False  # 加粗
        font.italic = False  # 倾斜
        font.color.rgb = RGBColor(254, 238, 159)  # 黄色
    else:
        textbox = copied_slide.shapes.add_textbox(Cm(3.75),
                                                  Cm(8.28),
                                                  Cm(30.11),
                                                  Cm(2.03)
                                                  )
        tf = textbox.text_frame
        para = tf.paragraphs[0]
        para.text = topicKey
        p = tf.add_paragraph()
        p.text=referee
        # 设置字体属性
        font = para.font
        font.size = Pt(20)  # 大小
        font.name = 'Arial'  # 字体
        font.bold = False  # 加粗
        font.italic = False  # 倾斜
        font.color.rgb = RGBColor(254, 238, 159)  # 黄色
        font = p.font
        font.size = Pt(20)  # 大小
        font.name = 'Arial'  # 字体
        font.bold = False  # 加粗
        font.italic = False  # 倾斜
        font.color.rgb = RGBColor(254, 238, 159)  # 黄色
def addQRcode(prs,back_ground_path,QR_path):
    blank_slide_layout = prs.slide_layouts[0]
    # add topic and author
    copied_slide = prs.slides.add_slide(blank_slide_layout)
    left = top = 0
    pic = copied_slide.shapes.add_picture(back_ground_path, left, top, height=prs.slide_height)
    textbox = copied_slide.shapes.add_textbox(Cm(0.77),
                                              Cm(0.82),
                                              Cm(32.35),
                                              Cm(1.79)
                                              )
    tf = textbox.text_frame
    para = tf.paragraphs[0]
    para.text = "Vote"
    # 设置字体属性
    font = para.font
    font.size = Pt(36)  # 大小
    font.name = 'Arial'  # 字体
    font.bold = True  # 加粗
    font.italic = False  # 倾斜
    font.color.rgb = RGBColor(51, 51, 51)  # 黑色
    copied_slide.shapes.add_picture(QR_path, Cm(9.38), Cm(3.96), Cm(13.45), Cm(13.45))

##添加一个slide的方法
##topicKey 'CC9', 'Ice breaker', 'Free speech'
##topic 演讲主题
##author 作者
##是否加书名号
def addSlide(BackGrounBase,prs,topicKey,topic,author,book_title_flag,topOrBottom,referee):
    blank_slide_layout = prs.slide_layouts[0]
    # add topic and author
    copied_slide = prs.slides.add_slide(blank_slide_layout)
    left = top = 0
    pic = copied_slide.shapes.add_picture(BackGrounBase,left, top, height = prs.slide_height)
    if(book_title_flag==True):
        addTopic(copied_slide,"《"+topic+"》",topOrBottom)
    else:
        addTopic(copied_slide,topic,topOrBottom)
    #addLogandTime
    addLogandTime(copied_slide,topOrBottom)
    if(author!=None):
        # sub title
        addtopicKey(copied_slide,topicKey,referee)
        # add author
        textbox = copied_slide.shapes.add_textbox(1524000,
                                                  5452870,
                                                  9144000,
                                                  914400
                                                  )
        tf = textbox.text_frame
        para = tf.paragraphs[0]
        para.text = author
        para.alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
        # 设置字体属性
        font = para.font
        font.size = Pt(28)  # 大小
        font.name = 'Arial'  # 字体
        font.bold = False  # 加粗
        font.italic = False  # 倾斜
        font.color.rgb = RGBColor(255, 255, 255)


def PREPARED(prs,sheet,BackGrounBase):
    preNum=(sheet.max_row-14-29-2)
    topicKey = ['CC9', 'Ice breaker', 'Free speech']
    subjectQ = queue.Queue(20)
    authorQ = queue.Queue(20)
    indivIndex=0
    actua_num=0
    GENERAL_EVALUATION=False
    GENERAL_index=0
    for i in range(30, sheet.max_row-9):
        check_pre=sheet.cell(row=29, column=5).value
        if(check_pre=="PREPARED SPEECH SESSION"):
            topic=sheet.cell(row=i, column=5).value
            author = sheet.cell(row=i, column=6).value
            if(topic!="INDIVIDUAL EVALUATION SESSION" and i<=(29+preNum/2) and indivIndex==0):
                suffix = (i - 30) % 3
                addSlide(BackGrounBase,prs,topicKey[suffix],topic,author,True,"top",None)
                actua_num=actua_num+1;
                subjectQ.put(topic)
                authorQ.put(author)
            elif(topic=="INDIVIDUAL EVALUATION SESSION" and indivIndex==0):
                indivIndex=i
                subjectInform= "INDIVIDUAL EVALUATION"
                addSlide(BackGrounBase,prs, " ", subjectInform, None, False,"bottom",None)
            elif(topic!="INDIVIDUAL EVALUATION SESSION" and indivIndex!=0 and i<=(indivIndex+actua_num)):
                subjectInform=subjectQ.get()
                referee=authorQ.get()
                addSlide(BackGrounBase,prs, "INDIVIDUAL EVALUATION Report for", "《"+subjectInform+"》", author, False, "top",referee)
            elif(topic!="INDIVIDUAL EVALUATION SESSION" and indivIndex!=0 and GENERAL_EVALUATION==False):
                GENERAL_EVALUATION=True
                subjectInform = "GENERAL EVALUATION"
                addSlide(BackGrounBase,prs, " ", subjectInform, None, False, "bottom",None)
            elif(topic!="INDIVIDUAL EVALUATION SESSION" and indivIndex!=0 and GENERAL_EVALUATION==True and GENERAL_index<4):
                if("General Evaluator Report"!=topic):
                    addSlide(BackGrounBase,prs, "GENERAL EVALUATION", topic, author, False, "top",None)
                else:
                    addSlide(BackGrounBase,prs," ","GENERAL EVALUATION",author,False,"top",None)
            else:
                continue
        else:
            raise Exception('EXCEL sheet 【会议议程前页】格式错误，请重新检查')

def updateppt(BackGrounBase,BackGroundQR,basePPTPath,baseExcelPath,sheetName,votingPicture,targetPath):
    prs = Presentation(basePPTPath)
    workbook = load_workbook(filename=baseExcelPath)
    sheet = workbook[sheetName]
    topicFlag = 0
    temptopic = " "
    slide = prs.slides[0]
    master_sharing = sheet.cell(row=22, column=5).value
    slide.shapes[1].text_frame.text = master_sharing
    createTime = slide.shapes[0].text_frame.paragraphs[1]
    createTime.text = getCurrentFriday()

    slide8 = prs.slides[8]
    createTime = slide8.shapes[0].text_frame.paragraphs[1]
    createTime.text = getCurrentFriday()

    slide9 = prs.slides[9]
    slide9.shapes[2].text_frame.text=sheet.cell(row=17, column=6).value
    slide9.shapes[3].text_frame.text="Shanghai L.E.P. Bilingual Toastmasters Club #185 | "+getCurrentFriday()

    slide10 = prs.slides[10]
    slide10.shapes[2].text_frame.text=sheet.cell(row=18, column=6).value
    slide10.shapes[3].text_frame.text="Shanghai L.E.P. Bilingual Toastmasters Club #185 | "+getCurrentFriday()

    slide11 = prs.slides[11]
    slide11.shapes[0].text_frame.text=sheet.cell(row=18, column=8).value
    slide11.shapes[1].text_frame.text=sheet.cell(row=18, column=9).value
    slide11.shapes[2].text_frame.text = "Shanghai L.E.P. Bilingual Toastmasters Club #185 | " + getCurrentFriday()
    slide11.shapes[2].text_frame.paragraphs[0].font.color.rgb = RGBColor(242, 242, 242)
    slide11.shapes[2].text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.RIGHT
    slide11.shapes[2].text_frame.paragraphs[0].font.size = Pt(18)

    slide12 = prs.slides[12]
    slide12.shapes[2].text_frame.text=sheet.cell(row=19, column=6).value
    slide12.shapes[3].text_frame.text="Shanghai L.E.P. Bilingual Toastmasters Club #185 | "+getCurrentFriday()

    slide13 = prs.slides[13]
    slide13.shapes[0].text_frame.text=sheet.cell(row=19, column=8).value
    slide13.shapes[1].text_frame.text=sheet.cell(row=19, column=9).value
    slide13.shapes[2].text_frame.text = "Shanghai L.E.P. Bilingual Toastmasters Club #185 | " + getCurrentFriday()
    slide13.shapes[2].text_frame.paragraphs[0].font.color.rgb = RGBColor(242, 242, 242)
    slide13.shapes[2].text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.RIGHT
    slide13.shapes[2].text_frame.paragraphs[0].font.size = Pt(18)

    slide14 = prs.slides[14]
    slide14.shapes[2].text_frame.text=sheet.cell(row=20, column=6).value
    slide14.shapes[3].text_frame.text="Shanghai L.E.P. Bilingual Toastmasters Club #185 | "+getCurrentFriday()

    #需要加时间规则
    addTimeRule(prs)

    slide16 = prs.slides[16]
    slide16.shapes[1].text_frame.text=sheet.cell(row=22, column=6).value
    slide16.shapes[1].text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
    slide16.shapes[2].text_frame.paragraphs[1].text=getCurrentFriday()

    slide17 = prs.slides[17]
    slide17.shapes[0].text_frame.text=sheet.cell(row=24, column=5).value
    slide17.shapes[2].text_frame.text=sheet.cell(row=24, column=6).value
    slide17.shapes[3].text_frame.text = "Shanghai L.E.P. Bilingual Toastmasters Club #185 | "+getCurrentFriday()

    slide18 = prs.slides[18]
    slide18.shapes[2].text_frame.text=sheet.cell(row=25, column=6).value
    slide18.shapes[3].text_frame.text = "Shanghai L.E.P. Bilingual Toastmasters Club #185 | "+getCurrentFriday()

    slide19 = prs.slides[19]
    slide19.shapes[1].text_frame.text=sheet.cell(row=27, column=6).value
    slide19.shapes[1].text_frame.paragraphs[0].alignment = PP_PARAGRAPH_ALIGNMENT.CENTER
    slide19.shapes[2].text_frame.text = "Shanghai L.E.P. Bilingual Toastmasters Club #185 | "+getCurrentFriday()

    slide8 = prs.slides[20]
    createTime = slide8.shapes[0].text_frame.paragraphs[1]
    createTime.text = getCurrentFriday()
    #备稿部分
    PREPARED(prs,sheet,BackGrounBase)
    #二维码
    addQRcode(prs,BackGroundQR,votingPicture)
    #致谢
    addSlide(BackGrounBase, prs, " ", "JOIN US", None, False, "bottom", None)
    addSlide(BackGrounBase, prs, " ", "AWARDING", None, False, "bottom", None)

    prs.save(targetPath)

if __name__ == '__main__':
    conn = ConfigParser()
    file_path=os.path.join(os.path.abspath('.'),'config.ini')
    if not os.path.exists(file_path):
        raise FileNotFoundError("文件不存在")

    conn.read(file_path)
    basePPTpath = conn.get('base', 'basePPTpath')
    baseExcelPath = conn.get('base', 'baseExcelPath')
    targetPPTpath = conn.get('base', 'targetPPTpath')
    sheetName = conn.get('base', 'sheetName')
    voting=conn.get('base', 'voting')
    BackGrounBase = conn.get('base', 'backGrounBase')
    BackGroundQR= conn.get('base', 'backGroundQR')
    updateppt(BackGrounBase,BackGroundQR,basePPTpath,baseExcelPath,sheetName,voting,targetPPTpath)

Window代码打包

pyinstaller -F operaPPT.py

Mac电脑打包python代码.

参考文档: pptx官网.

geyueguiDai
关注
  • 0
    点赞
  • 踩
  • 7
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
python自动办公 批量生成PPT版荣誉证书
11-08
本主题聚焦于使用Python批量生成PPT版荣誉证书，这涉及到Python编程、文件操作、PPT处理等多个知识点。 首先，我们需要了解如何利用Python进行文件操作。在描述中提到的“批量生成”意味着我们需要读取数据源，可能...
python批量生成PPT版荣誉证书
01-27
在这个场景中，我们要讨论的是如何使用Python来批量生成PPT（PowerPoint）版本的荣誉证书。这通常涉及到读取数据、模板处理以及文件输出等多个步骤。下面将详细介绍这个过程。 首先，你需要一个数据源，比如CSV或...
python excel模板_如何利用Excel与Python制作PPT
weixin_39532421的博客
11-28 391
对外汉语课堂中需要制作PPT。有些PPT的版式是相对固定的，如果数量巨大的话，可以利用python的pptx插件，与excel相结合，制作PPT。完整工作流有些复杂，所以分为4个部分来说明。PPT准备篇：编辑PPT母版版式梳理PPT样式的种类，然后利用PPT的母版版式，制作固定样式的PPT。在梳理PPT样式的种类时，要把例句的字数考虑进去，分为短例句样式（一般20个字以内），以及长例句样式（20个...
python把excel变成ppt_用Python写excel和ppt文件
weixin_39809584的博客
12-10 939
#xlsx和xls#一：openpyxl只能读取xlsx推荐使用的二种方法#因为excle文件中可以有多个编排故可以返回字典#该方法只适应于xlsx文件,不能处理xls文件'''fromopenpyxl.reader.excelimportload_workbookdefreadXlsxFile(path):dic={}#打开文件file=load_workbook(filenam...
没想到表格还能这么玩！用 Python 生成动态 PPT
a1137588003的博客
08-08 344
这篇文章就介绍了 Python 中一种简单的动态图表制作方法，这样生成的动图就可以丰富我们的PPT啦~数据暴增的年代，数据科学家、分析师在被要求对数据有更深的理解与分析的同时，还需要将结果有效地传递给他人。如何让目标听众更直观地理解？当然是将数据可视化啊，而且最好是动态可视化。。接触过数据可视化的同学应该对 Python 里的 Matplotlib 库并不陌生。它是一个基于 Python 的开源数据绘图包，仅需几行代码就可以帮助开发者生成直方图、功率谱、条形图、散点图等。
excel自动生成舒尔特表_EXCEL自动生成的PPT
weixin_39704727的博客
11-30 1230
因为经常要做周报、月报PPT，每次重复的的操作效率很低，这里整理了一套可以自动生成PPT的办法。首先，大概思路是这样的。周报、月报这类经营分析类PPT一般都是由表格、图表以及分析文字组成的，整体结构相对固定。先利用EXCEL的获取数据功能获取数据库、网页数据，或者手工建立一个基础表（数据库）；然后用EXCEL生成表格，图表，并利用函数生成分析文字（可根据数据更新）；再通过PPT直接调用EXCEL内...
excel的数据通过pyecharts生成图表，插入ppt
热门推荐
木头大左的博客
06-25 1万+
一、安装pyecharts,xlrd 直接采用pip install pyecharts，会安装最新版本，应该是1.2.1，很多接口已经变化了，这里还是安装老版本，且不需要ssl和https认证，命令如下 pip install -i http://mirrors.aliyun.com/pypi/simple/ pyecharts==0.1.9.4 --trusted-host mirrors...
零基础快速上手！实现Python办公自动化：操作Excel、Word、PDF、PPT等（附实战案例源码）
分享Python知识
02-05 1113
零基础快速上手！实现Python办公自动化：操作Excel、Word、PDF、PPT等（附实战案例源码）
通过python生成word和excle和ppt案例
完颜振江
02-15 481
这些示例展示了如何使用Python中的不同库来生成Word、Excel和PPT文件。您可以根据需要进一步定制和扩展这些示例。请确保安装相应的库（如。
自动生成ppt的基础包
12-23
在描述中提到的"excel生成ppt基础包"，意味着我们可以利用Excel中的数据来自动化构建PPT内容。这通常涉及到以下知识点： 1. **VBA（Visual Basic for Applications）**：VBA是Excel内置的编程语言，允许用户编写宏...
基于python自动办公-02 批量生成PPT版荣誉证书
最新发布
04-01
在本课程"基于python自动办公-02 批量生成PPT版荣誉证书"中，我们将探讨如何利用Python编程语言高效地批量创建PPT格式的荣誉证书。这是一项非常实用的技能，尤其对于处理大量类似文档的情况，如学校、公司或组织的...
python自动办公-02 批量生成PPT版荣誉证书
11-04
在本课程"Python自动办公-02 批量生成PPT版荣誉证书"中，我们将深入探讨如何利用Python编程语言高效地自动化创建批量PPT荣誉证书。这一过程涉及到多个Python库和技术，包括文本处理、图像操作以及PPT文档生成。 ...
在excel中用VBA生成PPT图表
djy_623047237的博客
06-18 2971
常常需要按照excel中的数据来在PPT中生成图表展示出来，有的方法是在excel生成好图表，再复制到ppt中，这里不采用。 这里先将excel数据读进数组，再在PPT中生成图表，将数组中的数据写进图表中的数据源里面，更改其数据源的默认区域。 Sub exctoppt() Dim pt As PowerPoint.Application, ob As PowerPoint.Shape, chartsheet As Worksheet Dim arr1() sourceaddress$ = Range(
Python 自动化教程(3) : 自动生成PPT文件 Part 1 (干货）
JoStudio
09-09 1万+
本人用 python 写了一个 office库，用于办公自动化，功能是很强的,包括：PPT自动生成、Word自动生成、Excel数据处理、PPT转长图、PPT带语音播放、office文档转为PDF、PDF加解密、加水印等等，都是干货。使用方法极简，大多数功能只需一行代码。比如： office.open_file("output.pptx", "template.pptx").fill('datafile.xlsx').save()............
自动批量一次性转换工具，doc转docx，xls转xlsx，ppt转pptx，基于python
weixin_43985754的博客
11-29 1005
【代码】自动批量一次性转换工具，doc转docx，xls转xlsx，ppt转pptx，基于python。
ppt制作工具python-pptx 快速入门
dx_shendu的博客
09-20 2429
ppt制作工具python-pptx 快速入门 转载：https://www.jianshu.com/p/23734d34d788 hello #!/usr/bin/env python3 # -*- coding: utf-8 -*- from pptx import Presentation prs = Presentation() title_slide_layout = p...
VBA根据Excel内容快速创建PPT
神奇的BI
11-05 1709
示例需求：根据Excel中选中的单元格内容（3列）如下图所示，在已打卡的PowerPoint文件中创建页面。 新增PPT Slide页面使用第二个模板页面，其中包含两个文本占位符，和一个图片占位符。将Excel选中区域中前两列写入文字占位符，第3列图片粘贴至图片占位符。
用Python自动化操作PPT，看完这篇文章就够了！
SeizeeveryDay的博客
03-21 1459
作者：超级大洋葱806https://tangxing.blog.csdn.net/article/details/109568830大家好，我是小z今天给大家分享一波Python自动化操...
QT属性动画--设置样式属性(其他属性)
lizequan的博客
03-02 5422
这里写自定义目录标题故事背景遇到的问题解决过程最终方法感悟 故事背景   最近在制作一个按钮切换的动画特效中接触了属性动画这部分内容，并由此产生了一些思考。 遇到的问题 解决过程 最终方法 感悟 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值