#!/usr/bin/env python3 """Поиск макросов в документах Office через oletools.""" from __future__ import annotations import argparse import json import os from pathlib import Path EXTENSIONS = {".doc", ".docm", ".docx", ".dotm", ".xls", ".xlsm", ".xlsx", ".xltm", ".ppt", ".pptm", ".pptx", ".potm"} SUSPICIOUS = ( "autoopen", "autoclose", "document_open", "workbook_open", "auto_open", "shell", "createobject", "wscript.shell", "powershell", "urldownloadtofile", "mshta", "base64", "environ(", "xmlhttp", ) def main() -> int: parser = argparse.ArgumentParser(description="Проверка макросов Office") parser.add_argument("--path", type=Path, required=True, help="Файл или каталог") parser.add_argument("--limit", type=int, default=100, help="Максимум файлов") parser.add_argument("--json", type=Path, help="Сохранить отчёт в JSON") args = parser.parse_args() try: from oletools.olevba import VBA_Parser except ImportError: print("Не установлен oletools. Выполните: python3 -m pip install oletools") return 2 source = args.path.expanduser().resolve() if not source.exists(): parser.error(f"Путь не найден: {source}") if source.is_file(): files = [source] else: files = [] for dirpath, dirnames, filenames in os.walk(source, followlinks=False): dirnames[:] = [d for d in dirnames if d not in {".git", "node_modules"}] for name in filenames: path = Path(dirpath) / name if path.suffix.lower() in EXTENSIONS: files.append(path) if len(files) >= args.limit: break if len(files) >= args.limit: break reports = [] for path in files[: args.limit]: report = {"file": str(path), "has_macros": False, "modules": 0, "keywords": [], "error": ""} parser_object = None try: parser_object = VBA_Parser(str(path)) if parser_object.detect_vba_macros(): report["has_macros"] = True found = set() modules = 0 for _filename, _stream, _vba_name, vba_code in parser_object.extract_macros(): modules += 1 text = str(vba_code).lower() for keyword in SUSPICIOUS: if keyword in text: found.add(keyword) report["modules"] = modules report["keywords"] = sorted(found) except Exception as error: report["error"] = str(error) finally: if parser_object is not None: try: parser_object.close() except Exception: pass reports.append(report) print(f"Проверено файлов: {len(reports)}") for report in reports: print() print(f" {report['file']}") if report["error"]: print(f" ошибка: {report['error']}") continue if report["has_macros"]: keywords = ", ".join(report["keywords"]) if report["keywords"] else "опасных ключевых слов не найдено" print(f" макросы: да, модулей: {report['modules']}") print(f" ключевые слова: {keywords}") else: print(" макросы: нет") if args.json: args.json.write_text(json.dumps({"files": reports}, ensure_ascii=False, indent=2) + "\n", encoding="utf-8") print(f"JSON сохранён: {args.json}") return 0 if __name__ == "__main__": raise SystemExit(main())