pip install openpyxl

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

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

# 定義邊框樣式
thin_border = Border(
    left=Side(style='thin'),      # 左邊框：細線
    right=Side(style='thin'),     # 右邊框：細線
    top=Side(style='thin'),       # 上邊框：細線
    bottom=Side(style='thin')     # 下邊框：細線
)

# 應用邊框到單元格范圍
for row in ws['A1:D4']:  # A1到D4的矩形區(qū)域
    for cell in row:
        cell.border = thin_border

wb.save("bordered_openpyxl.xlsx")

from openpyxl.styles import borders

# 自定義不同邊的樣式
mixed_border = Border(
    left=Side(style='medium', color='FF0000'),  # 紅色中等粗細左邊框
    top=Side(style='dashed'),                   # 虛線上邊框
    bottom=Side(style='double')                 # 雙線下邊框
)

ws['B2'].border = mixed_border  # 僅對B2單元格應用混合邊框
wb.save("mixed_borders.xlsx")

pip install xlsxwriter

import xlsxwriter

# 創(chuàng)建工作簿
workbook = xlsxwriter.Workbook('bordered_xlsxwriter.xlsx')
worksheet = workbook.add_worksheet()

# 定義邊框格式
border_format = workbook.add_format({
    'border': 1,  # 1=細線，2=中等，3=粗線
    'align': 'center'
})

# 應用格式到單元格范圍
worksheet.write('A1', 'Header', border_format)
worksheet.write_row('A2:D2', [1, 2, 3, 4], border_format)  # 第二行整行加邊框

workbook.close()

# 定義復雜邊框格式
complex_format = workbook.add_format({
    'top': 2,          # 上邊框：中等粗細
    'bottom': 3,       # 下邊框：粗線
    'left': 1,         # 左邊框：細線
    'right': 4,        # 右邊框：雙線（xlsxwriter特有）
    'bg_color': '#F2F2F2'  # 背景色（可選）
})

worksheet.merge_range('A1:D1', 'Report Title', complex_format)  # 合并單元格并應用邊框
workbook.close()

import pandas as pd

# 創(chuàng)建DataFrame
df = pd.DataFrame({'Name': ['Alice', 'Bob'], 'Score': [90, 85]})

# 寫入Excel并設(shè)置邊框
with pd.ExcelWriter('pandas_bordered.xlsx', engine='xlsxwriter') as writer:
    df.to_excel(writer, sheet_name='Sheet1', index=False)
    
    # 獲取工作簿和工作表對象
    workbook = writer.book
    worksheet = writer.sheets['Sheet1']
    
    # 定義邊框格式
    border_format = workbook.add_format({'border': 1})
    
    # 應用邊框到數(shù)據(jù)區(qū)域（A1:B3）
    worksheet.conditional_format(
        'A1:B3', {'type': 'no_errors', 'format': border_format}
    )