Python-pptx无法移除指定单元格边框问题求助

我需要移除PPT表格中指定单元格的边框，但当前代码无法实现该功能。已尝试相关解决方案但无效，希望能实现指定边框（如仅顶部或上下边框）的移除，恳请提供帮助。

from pptx.enum.text import PP_ALIGN
from pptx.util import Inches, Mm, Pt, Emu
from pptx.enum.dml import MSO_FILL_TYPE
from pptx.oxml.xmlchemy import OxmlElement
from datetime import date
import pandas as pd
import numpy as np
from pptx import Presentation  # 补充原代码缺失的导入

#region 读取模板并加载
path = "Template/Template.pptx"
prs = Presentation(path)
#endregion

#region 自定义函数
def SubElement(parent, tagname, **kwargs):
    element = OxmlElement(tagname)
    element.attrib.update(kwargs)
    parent.append(element)
    return element


def _set_cell_border(cell, border_color="FFFFFF", border_width='12700'):
    """ 用于设置边框宽度和颜色的工具函数
        - 当前仅支持底部边框
        (c) Steve Canny
    """
    tc = cell._tc
    tcPr = tc.get_or_add_tcPr()

    lnB = SubElement(tcPr, 'a:lnB', w=border_width, cap='flat', cmpd='sng', algn='ctr')
    solidFill = SubElement(lnB, 'a:NoFill')

#endregion
#region 生成测试数据
df = pd.DataFrame()
df["name"] = ["Nick","Gaetano", "George", "Jason","Death", "God", 'Stan', "Satan","Beel","Nick","Gaetano", "George", "Jason","Death", "God", 'Stan', "Satan","Beel"]
df["Restaurant Manager"] = ["Sam","Mason", "Sam", "Mason","Mason","Sam","Sam","Sam","Mason","Sam","Mason", "Sam", "Mason","Mason","Sam","Sam","Sam","Mason"]
df["Score"] = np.random.randint(5,30,size=18)
df['Percentile Rank'] = np.random.randint(5,101,size=18)
df["Restaurant Name"] = ["Elise","Bob","Death","Elise","Bob","Death","Elise","Bob","Death","Elise","Bob","Death","Elise","Bob","Death","Elise","Bob","Death"]
df = df[df.groupby(['Restaurant Name', 'Restaurant Manager']).cumcount() < 3]

#endregion

#region 获取布局信息（注释掉的调试代码）
#slide = prs.slides.add_slide(prs.slide_layouts[3])
#for shape in slide.placeholders:
#    print('%d %s' % (shape.placeholder_format.idx, shape.name))

#endregion

#region 创建第3页表格幻灯片
slide_layout = prs.slide_layouts[3]
slide = prs.slides.add_slide(slide_layout)
placeholder = slide.placeholders[0]
placeholder.text = "Restaurant TABLE Analysis"
table_placeholder = slide.shapes[1]
shape = table_placeholder.insert_table(rows=13, cols=14)
table = shape.table

#endregion

#region 设置表格参数
# 将所有单元格字体设为1号（隐藏默认文本）
for row in table.rows:
    for cell in row.cells:
        for paragraph in cell.text_frame.paragraphs:
            paragraph.font.size = Pt(1)

rownumbers= [1,7]
colnumbers = [4,9]

# 设置指定行透明背景和高度
for i in rownumbers:
    row = table.rows[i]
    for cell in row.cells:
        cell.text_frame.paragraphs[0].font.size = Pt(1)
        cell.fill.background()
    row.height = Mm(2)

# 设置指定列透明背景和宽度
for i in colnumbers:
    column = table.columns[i]
    column_index = i
    for row in table.rows:
        cell = row.cells[column_index]
        cell.text_frame.paragraphs[0].font.size = Pt(1)
        cell.fill.background()
    column.width = Mm(2)

# 合并指定行的所有单元格
for row_index in rownumbers:
    row = table.rows[row_index]
    first_cell = row.cells[0]
    last_cell = row.cells[-1]
    first_cell.merge(last_cell)
#endregion

#region 填充表格数据
# 按餐厅名称分组
groups = df.groupby('Restaurant Name')

i = 0
for name, group in groups:
    # 写入餐厅名称并合并单元格
    cell = table.cell(0, i)
    cell.text = name
    cell.text_frame.paragraphs[0].font.size = Pt(18)
    cell.text_frame.paragraphs[0].alignment = PP_ALIGN.CENTER
    cell.merge(table.cell(0, i+3))

    # 按餐厅经理分组
    df_manager_grouped = group.groupby('Restaurant Manager')
    i_2 = 2
    for manager_name, manager_group in df_manager_grouped:
        # 写入经理名称并合并单元格
        cell = table.cell(i_2, i)
        cell.text = manager_name
        cell.text_frame.paragraphs[0].font.size = Pt(12)
        cell.text_frame.paragraphs[0].alignment = PP_ALIGN.CENTER
        cell.merge(table.cell(i_2, i+3))

        # 写入员工数据
        row_index = i_2 + 2
        for index in range(len(manager_group)):
            cell = table.cell(row_index, i)
            cell.text = str(index + 1)
            cell.text_frame.paragraphs[0].font.size = Pt(12)
            cell.text_frame.paragraphs[0].alignment = PP_ALIGN.CENTER

            cell = table.cell(row_index, i + 1)
            cell.text = manager_group.iloc[index]['name']
            cell.text_frame.paragraphs[0].font.size = Pt(12)
            cell.text_frame.paragraphs[0].alignment = PP_ALIGN.LEFT

            cell = table.cell(row_index, i + 2)
            cell.text = str(manager_group.iloc[index]['Score'])
            cell.text_frame.paragraphs[0].font.size = Pt(12)
            cell.text_frame.paragraphs[0].alignment = PP_ALIGN.CENTER

            cell = table.cell(row_index, i + 3)
            cell.text = str(manager_group.iloc[index]['Percentile Rank'])
            cell.text_frame.paragraphs[0].font.size = Pt(12)
            cell.text_frame.paragraphs[0].alignment = PP_ALIGN.CENTER

            row_index += 1
        i_2 += 6
    i += 5

# 居中表格
slide_width = prs.slide_width
table_width = shape.width
shape.left = round((slide_width - table_width) / 2)

# 原边框设置调用（无效）
cell = table.cell(6,4)
_set_cell_border(cell)

#endregion

prs.save('test.pptx')

原函数_set_cell_border仅支持底部边框，且未处理单元格原有边框样式导致失效。替换为以下函数，可精准移除指定方向的边框：

def remove_cell_borders(cell, borders_to_remove=['top', 'bottom', 'left', 'right']):
    tc = cell._tc
    tcPr = tc.get_or_add_tcPr()
    
    # 边框方向与XML标签的映射
    border_tag_map = {
        'top': 'a:lnT',
        'bottom': 'a:lnB',
        'left': 'a:lnL',
        'right': 'a:lnR'
    }
    
    for border in borders_to_remove:
        tag = border_tag_map.get(border)
        if not tag:
            continue
        
        # 先删除已存在的对应边框元素，避免默认样式干扰
        existing_border = tcPr.find(tag)
        if existing_border is not None:
            tcPr.remove(existing_border)
        
        # 添加无填充、宽度为0的边框配置，强制隐藏该方向边框
        ln_element = SubElement(tcPr, tag, w='0', cap='flat', cmpd='sng', algn='ctr')
        SubElement(ln_element, 'a:NoFill')

使用示例 #

• 移除指定单元格的顶部和底部边框：

cell = table.cell(6,4)
remove_cell_borders(cell, borders_to_remove=['top', 'bottom'])

• 移除单元格所有边框：

remove_cell_borders(cell)

原理说明 #

1. 先删除单元格原有对应方向的边框XML元素，消除默认样式的影响；
2. 添加宽度为0且无填充的边框配置，让PPT不再渲染该方向的边框。

内容的提问来源于stack exchange，提问作者Gaetano Dona-Jehan