pip install openpyxl

import openpyxl
# 打開Excel文件
wb = openpyxl.load_workbook('example.xlsx')
# 選擇工作表
worksheet = wb['Sheet1']

# 復制條件格式
# worksheet_target：需要被復制的目標sheet
# worksheet：當前sheet
def copyFormat(worksheet_target, worksheet):
    # 獲取原有sheet規(guī)則的字典
    cf_rules: dict = worksheet_target.conditional_formatting._cf_rules
    # 遍歷規(guī)則字典
    for key in cf_rules:
        # 定義單元格名稱（需要添加的規(guī)則的單元格名稱）
        coord = ""
        # 獲取規(guī)則中的ranges（set集合）ranges包含cells等對象數(shù)據(jù)
        ranges: set = key.cells.ranges
        # 遍歷ranges獲取每個單元格名稱
        for cellRange in ranges:
            # 將單元格名稱進行組合 示例：A1:B2 B3:H5
            coord += cellRange.coord + " "
        # 獲取規(guī)則列表
        rules = cf_rules[key]
        for rule in rules:
            # 給指定sheet添加原有單元格的規(guī)則
            worksheet.conditional_formatting.add(coord, rule)

# 加載源Excel文件
wb_src = load_workbook('source.xlsx')
# 加載源Sheet
ws_src = wb_src['Sheet1']
# 加載目標Excel文件
wb_dest = load_workbook('destination.xlsx')
# 加載目標Sheet
ws_dest = wb_dest['Sheet1']

# 復制條件格式
copyFormat(ws_src, ws_dest)

# 保存目標Excel文件
wb_dest.save('destination.xlsx')