【批量办公技巧】多Excel文件一键查找并汇总命中行结果到文件

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
批量查找替换服务类
提供Excel文件中的批量查找替换功能的核心实现
"""
import os
import re
from pathlib import Path

import openpyxl
from openpyxl.styles import Font, PatternFill
from openpyxl.utils import get_column_letter

from api.excel_api import ExcelAPI
from utils.logger import info, error, warning, debug
from utils import FileUtils


class FindReplaceService:
    """批量查找替换服务类"""
    
    def __init__(self):
        """初始化服务"""
        self.excel_api = ExcelAPI()
    
    def get_excel_files(self, directory):
        """获取目录下的所有Excel文件"""
        return FileUtils.list_files(directory,['.xlsx', '.xls'])

    def find_replace_in_excel(self, excel_file , output_file  ,args):
        """在Excel文件中查找并替换文本
        """
        find_text = args['find_text']
        replace_text = args['replace_text']
        match_mode = args['match_mode']
        case_sensitive = args['case_sensitive']
        bg_color = args['bg_color']
        font_name = args['font_name']
        font_size = args['font_size']
        font_color = args['font_color']
        cell_range = args.get('cell_range')
        highlight_row = args.get('highlight_row', False)
        extractData = args.get('extractData', False)

        self.excel_api.find_replace(excel_file , output_file , {
            "find_text":find_text,
            "replace_text":replace_text,
            "match_mode":match_mode,
            "case_sensitive":case_sensitive,
            "bg_color":bg_color,
            "font_name":font_name,
            "font_size":font_size,
            "font_color":font_color,
            "cell_range":cell_range,
            "heightRow":highlight_row,
            "extractData":extractData
        })