from openpyxl import Workbook
from openpyxl.styles import Border, Side

# 創(chuàng)建工作簿和工作表
wb = Workbook()
ws = wb.active

# 1. 定義"邊" (Side)
# style='thin' 表示細(xì)邊框, color='000000' 表示黑色
thin_side = Side(border_style="thin", color="000000")

# 2. 定義"框" (Border)
# 將上下左右都設(shè)置為上面定義的樣式
my_border = Border(left=thin_side, 
                   right=thin_side, 
                   top=thin_side, 
                   bottom=thin_side)

# 3. 應(yīng)用到單元格
ws['A1'].value = "Hello Border"
ws['A1'].border = my_border

# 保存文件
wb.save("border_demo.xlsx")

from openpyxl.styles import Border, Side

# 定義粗紅邊
thick_red_side = Side(border_style="thick", color="FF0000")
red_border = Border(left=thick_red_side, 
                    right=thick_red_side, 
                    top=thick_red_side, 
                    bottom=thick_red_side)

ws['B2'].border = red_border

# 頂部和左右是細(xì)線，底部是粗線
thin_side = Side(border_style="thin", color="000000")
thick_side = Side(border_style="thick", color="000000")

mixed_border = Border(left=thin_side, 
                      right=thin_side, 
                      top=thin_side, 
                      bottom=thick_side) # 底部不同

ws['C3'].border = mixed_border

def set_border_for_range(ws, cell_range, border_style):
    """
    為指定區(qū)域設(shè)置邊框
    :param ws: Worksheet對象
    :param cell_range: 單元格區(qū)域字符串，如 "A1:D5"
    :param border_style: Border對象
    """
    rows = ws[cell_range]
    for row in rows:
        for cell in row:
            cell.border = border_style

# 使用示例
my_border = Border(left=Side(style='thin'), 
                   right=Side(style='thin'), 
                   top=Side(style='thin'), 
                   bottom=Side(style='thin'))

set_border_for_range(ws, "A5:E10", my_border)

double_side = Side(border_style="double", color="000000")
total_border = Border(top=Side(style='thin'), bottom=double_side)
ws['D12'].border = total_border  # 典型的會計合計樣式

def border_factory(style='thin', color='000000', sides='all'):
    """
    快速生成Border對象
    :param sides: 'all', 'top_bottom', 'left_right', 或自定義列表 ['top', 'left']
    """
    side = Side(border_style=style, color=color)
    
    kwargs = {}
    if sides == 'all':
        target_sides = ['left', 'right', 'top', 'bottom']
    elif sides == 'top_bottom':
        target_sides = ['top', 'bottom']
    elif sides == 'left_right':
        target_sides = ['left', 'right']
    else:
        target_sides = sides
        
    for s in target_sides:
        kwargs[s] = side
        
    return Border(**kwargs)

# 使用
ws['A1'].border = border_factory(style='medium', color='0000FF')

data = [85, 92, 58, 77, 45]
red_box = border_factory(style='medium', color='FF0000')

for i, score in enumerate(data, start=1):
    cell = ws.cell(row=i, column=1, value=score)
    if score < 60:
        cell.border = red_box

# ? 推薦做法：只創(chuàng)建一個對象
common_border = Border(left=Side(style='thin'), right=Side(style='thin'), ...)

for row in ws.iter_rows(min_row=1, max_row=10000):
    for cell in row:
        cell.border = common_border

# ? 不推薦做法：每次循環(huán)都創(chuàng)建新對象
for row in ws.iter_rows(...):
    for cell in row:
        # 這樣會創(chuàng)建數(shù)萬個Side和Border實例，極其浪費
        cell.border = Border(left=Side(style='thin')...)

from openpyxl import Workbook
from openpyxl.styles import Border, Side, PatternFill, Font

def set_outer_border(ws, cell_range, style='thick'):
    """給整個區(qū)域的外圍畫框，內(nèi)部不畫"""
    rows = list(ws[cell_range])
    side = Side(border_style=style)
    
    # 第一行設(shè)上邊框，最后一行設(shè)下邊框
    for cell in rows[0]:
        cell.border = cell.border + Border(top=side)
    for cell in rows[-1]:
        cell.border = cell.border + Border(bottom=side)
        
    # 第一列設(shè)左邊框，最后一列設(shè)右邊框
    for row in rows:
        row[0].border = row[0].border + Border(left=side)
        row[-1].border = row[-1].border + Border(right=side)

wb = Workbook()
ws = wb.active

# 模擬數(shù)據(jù)
data = [
    ["姓名", "部門", "銷售額"],
    ["張三", "銷售一部", 5000],
    ["李四", "銷售二部", 7000],
    ["王五", "銷售一部", 6200],
]

# 寫入數(shù)據(jù)
for row in data:
    ws.append(row)

# 1. 基礎(chǔ)全細(xì)邊框
thin_border = Border(left=Side(style='thin'), 
                     right=Side(style='thin'), 
                     top=Side(style='thin'), 
                     bottom=Side(style='thin'))

for row in ws.iter_rows(min_row=1, max_row=4, min_col=1, max_col=3):
    for cell in row:
        cell.border = thin_border

# 2. 表頭美化（底色 + 粗底邊）
header_fill = PatternFill(start_color="DDDDDD", end_color="DDDDDD", fill_type="solid")
header_bottom_border = Border(left=Side(style='thin'), 
                              right=Side(style='thin'), 
                              top=Side(style='thin'), 
                              bottom=Side(style='thick')) # 表頭下邊緣加粗

for cell in ws[1]:
    cell.fill = header_fill
    cell.font = Font(bold=True)
    # 注意：直接賦值會覆蓋上面的全細(xì)邊框，所以這里重新定義了完整的Border
    cell.border = header_bottom_border

# 3. 給整個表格加一個粗外框
set_outer_border(ws, "A1:C4", style="thick")

wb.save("professional_table.xlsx")