如何修复Python openpyxl中Cell B6的底部边框缺失问题

The issue likely stems from incorrect handling of border style definitions or unintended overwriting of existing cell borders. Here's how to resolve it:

1. Correctly Define Border Styles #

First, ensure your border styles are defined as Side objects (not full Border objects), since openpyxl requires Side instances for individual border edges:

from openpyxl.styles import Border, Side

# Define border sides (use these for individual edges)
thin_side = Side(style='thin', color='000000')
thick_side = Side(style='thick', color='000000')
no_side = Side(style='none')

2. Fix the Border Assignment Loop #

Update your code to preserve existing border styles for left/top edges (to avoid accidental gaps) and correctly apply the intended bottom/right borders:

for row in sheet['A6:E6']:
    for cell in row:
        # Keep existing left and top borders to prevent unintended removal
        current_left = cell.border.left
        current_top = cell.border.top
        
        # Set bottom border: thick for A6-D6, none for E6
        bottom_side = thick_side if cell.column != 5 else no_side
        # Set thin right border for all cells
        right_side = thin_side
        
        # Apply the complete border configuration
        cell.border = Border(
            left=current_left,
            top=current_top,
            bottom=bottom_side,
            right=right_side
        )

Why This Works #

• Using Side objects directly ensures openpyxl applies styles to the correct cell edges without confusion.
• Preserving existing left/top borders prevents accidental removal of any pre-configured styles that might have been causing visual gaps.
• The condition cell.column !=5 correctly targets column E (the 5th column) to exclude its bottom border, while applying the thick bottom border to all other cells in the range.

内容的提问来源于stack exchange，提问作者Gordon Chao