python ppt表格样式展示

àì夳堔傛蜴生んèń 2023-06-13 09:44 1阅读 0赞

本篇文章是对另一篇文章的补充，好多情况下会遇到样式的改变。在这里出现情况较多的时候可以封装为函数，方便调用，复写。  
\# -\*- coding: utf-8 -\*-  
from pptx import Presentation  
from pptx.enum.text import PP\_PARAGRAPH\_ALIGNMENT  
from pptx.chart.data import ChartData  
from pptx.util import Pt  
from pptx.dml.color import RGBColor

def write\_cell(table, row, col, content, size, name,rgb):  
    table.cell(row, col).text\_frame.clear()  
    new = table.cell(row, col).text\_frame.paragraphs\[0\]  
    new.alignment = PP\_PARAGRAPH\_ALIGNMENT.CENTER  
    new.text = content  
    new.font.size = Pt(size)  
    new.font.name = name  
    new.font.color.rgb = rgb

def ppt(prs,template\_path):  
    \# 表格  
    table = \[tb.table for tb in slide.shapes if tb.has\_table\]\[0\]  
    values = \[\]  
    for row in range(1,3):  
        value = \[\]  
        for col in range(1,8):  
            if type(sheet.cell(row, col).value) == type(1.1) and col== 7:  
                s = str(round(sheet.cell(row, col).value \* 100,2)) + '%'  
            elif type(sheet.cell(row, col).value) == type(1.1) and col in \[1,2,3,4,5,6\]:  
                s = str(round(sheet.cell(row, col).value))  
            else :  
                s = str(sheet.cell(row, col).value)  
            value.append(s)  
        values.append(value)  
    for i in range(len(table.rows)):  
        for j in range(len(table.columns)):  
            if  values\[i\]\[j\].startswith('-'):  
                write\_cell(table, i, j, str(values\[i\]\[j\]), 18, "宋体",RGBColor(255, 0, 0))  
            else:      
                write\_cell(table, i, j, str(values\[i\]\[j\]), 14, "宋体",RGBColor(0, 0, 0))