【自动化办公】批量设置Excel样式格式（如：纸张大小，排版，字体等）+ 支持windows系统

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Excel格式设置服务类
提供Excel文件格式设置的核心功能
"""

import os
import json
from pathlib import Path
from typing import Dict, List, Any

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


class ExcelSettingsService:
    """Excel格式设置服务类"""
    
    def __init__(self):
        """初始化服务"""
        self.excel_api = ExcelAPI()


    def apply_format_to_excel(self, excel_file: str, format_name: str, output_file: str = None) -> bool:
        """将格式应用到Excel文件"""
        format_settings = get_format_by_name(format_name)
        # 调用API接口应用格式设置
        self.excel_api.apply_excel_format(excel_file, format_settings, output_file)

    def get_excel_files(self, directory: str) -> List[str]:
        """获取目录下的所有Excel文件"""
        excel_files = []
        try:
            for root, dirs, files in os.walk(directory):
                # 跳过out.error目录
                if "out" in dirs:
                    dirs.remove("out")
                if "error" in dirs:
                    dirs.remove("error")
                for file in files:
                    if file.lower().endswith(('.xlsx', '.xls')):
                        excel_files.append(os.path.join(root, file))
        except Exception as e:
            error(f"扫描Excel文件失败: {str(e)}")
        
        return excel_files
    
    @staticmethod
    def validate_directory(directory: str) -> bool:
        """验证目录是否有效"""
        return os.path.exists(directory) and os.path.isdir(directory)