← Back to Skills Marketplace
Sop Bom Report
by
2656255594
· GitHub ↗
· v1.4.3
· MIT-0
206
Downloads
0
Stars
0
Active Installs
13
Versions
Install in OpenClaw
/install sop-bom-report
Description
SOP与BOM对比校对,生成独立校对报告。支持单个SOP与多个BOM合并校对。从SOP提取物料信息(含页码、序号),与BOM对比,生成包含三个表格的报告:有差异物料(并排对比)、SOP独有物料、BOM独有物料。差异用红色标注,重复物料编码用黄色标注。保留SOP中所有重复物料条目不合并,逐条与BOM对比校对。自动清...
Usage Guidance
This skill appears coherent and limited to local SOP/BOM Excel processing. Before running: (1) review the included script yourself or run it in an isolated environment (container/VM) if you have low trust in the source; (2) install openpyxl only if you need numeric-cell support; (3) be cautious with files that contain macros (xlsm) — this script parses XLSX XML and does not execute VBA, but opening or executing untrusted Office files elsewhere can be dangerous; (4) note the cleanup behavior: generated temp/extract/report files under the system temp directory matching sop_extract_*, bom_extract_* and report_* will be removed and old reports pruned — back up any important files outside temp; (5) avoid running the script with elevated privileges. If you want higher assurance, request the full, non-truncated source for review (to confirm there are no network calls or subprocess executions elsewhere in the file).
Capability Analysis
Type: OpenClaw Skill
Name: sop-bom-report
Version: 1.4.3
The skill bundle is a functional tool for comparing SOP (Standard Operating Procedure) and BOM (Bill of Materials) Excel files. The core logic in `scripts/sop_bom_report.py` implements manual XLSX parsing and generation by directly manipulating the underlying XML structures, which is a legitimate approach to minimize dependencies. It includes a cleanup routine that manages its own temporary files and old reports using specific naming patterns (e.g., `sop_extract_*`). No indicators of data exfiltration, malicious execution, or prompt injection were found.
Capability Assessment
Purpose & Capability
The name/description (SOP与BOM对比校对并生成 Excel 报告) align with the provided Python script and SKILL.md. The script parses XLSX (by extracting its ZIP and reading XML/sharedStrings) and optionally uses openpyxl for numeric cells — all consistent with the stated functionality. No unrelated services, credentials, or binaries are requested.
Instruction Scope
SKILL.md directs the agent/user to run the included Python script and to provide SOP/BOM files. The instructions reference only local files, temp directories, and optional openpyxl. The script reads/extracts XLSX contents, writes temporary extract dirs under the system temp dir, and writes output XLSX reports. It does not instruct network transmission or reading unrelated system configuration. Note: SKILL.md also documents manual rm/Remove-Item commands for cleaning temp patterns — these are standard but can be risky if copy-pasted with modified paths.
Install Mechanism
There is no install spec; this is instruction-only with one included Python script. The only optional dependency is openpyxl (pip install openpyxl), which is appropriate for reading Excel numeric values. No external downloads or archive extraction steps beyond handling XLSX files are present.
Credentials
The skill declares no required environment variables, credentials, or config paths. The script uses the system temporary directory and current working directory for input/output, which is proportionate to its purpose. Troubleshooting mentions setting TEMP, which is a benign suggestion.
Persistence & Privilege
The skill is not always-enabled and does not request elevated or persistent platform privileges. It implements automatic cleanup of its own temp/extract/report files (patterns sop_extract_*, bom_extract_*, report_*) and removes old reports (policy: keep 20, delete >7 days). This is reasonable for a reporting tool, but users should note it will delete matching files in the system temp directory — if you (or other tools) put unrelated files with those same name patterns in temp they may be removed.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install sop-bom-report - After installation, invoke the skill by name or use
/sop-bom-report - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.4.3
保留SOP中所有重复物料条目不合并,逐条与BOM对比校对。修复去重逻辑,确保重复物料编码用黄色标注并全部显示在报告中。
v1.4.2
v1.4.2: 列宽自适应内容长度(中文2字符,英文1字符),行距优化(标题25pt, 表头22pt, 数据行20pt)
v1.4.1
v1.4.1: 优化报告行距显示(标题25pt, 表头22pt, 数据行20pt),调整列宽更清晰
v1.4.0
v1.4.0: 智能检测位号格式,自动调整报告列。位号必须是有效格式(如R1,C2,U3)才显示,否则隐藏位号列。
v1.3.1
v1.3.1: 修复 openpyxl 读取性能问题,改为只读取指定物料行的数量数据,避免遍历整个文件导致超时
v1.3.0
v1.3.0: 新增 openpyxl 混合解析支持,可正确读取数值类型的数量数据;支持 AR 列物料编码格式;改进跨平台兼容性(Windows/Mac/Linux)
v1.2.4
优化:保留标准格式提取逻辑(AQ+AN序号1-20),新增兼容模式作为后备方案
v1.2.3
重大更新:SOP 文件支持多列物料编码提取(AQ/AX/AN/BU/BF),兼容不同格式的 SOP 文件;取消序号强制验证,提高提取成功率
v1.2.2
新增:自动识别两种 BOM 格式(新格式: F/G/H/I/K/L/M 列,旧格式: H/I/J/K/N/O/P 列),优先检测新格式
v1.2.1
更新文档:明确说明支持多个BOM文件合并校对功能
v1.2.0
v1.2.0: 完整 Windows 兼容性支持 - 添加 safe_rmtree 函数处理 Windows 权限问题,使用 tempfile.gettempdir() 替代硬编码路径,添加环境信息打印,改进错误处理
v1.1.0
v1.1.0: 跨平台兼容性修复 - 使用 tempfile.gettempdir() 替代硬编码 /tmp,添加 Python 3.8+ 版本检查,添加依赖声明和环境要求说明
v1.0.0
初始版本:纯 XML 方式生成 SOP-BOM 校对报告,支持页码序号提取、差异并排对比、颜色标注、自动缓存清理
Metadata
Frequently Asked Questions
What is Sop Bom Report?
SOP与BOM对比校对,生成独立校对报告。支持单个SOP与多个BOM合并校对。从SOP提取物料信息(含页码、序号),与BOM对比,生成包含三个表格的报告:有差异物料(并排对比)、SOP独有物料、BOM独有物料。差异用红色标注,重复物料编码用黄色标注。保留SOP中所有重复物料条目不合并,逐条与BOM对比校对。自动清... It is an AI Agent Skill for Claude Code / OpenClaw, with 206 downloads so far.
How do I install Sop Bom Report?
Run "/install sop-bom-report" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Sop Bom Report free?
Yes, Sop Bom Report is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Sop Bom Report support?
Sop Bom Report is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Sop Bom Report?
It is built and maintained by 2656255594 (@2656255594); the current version is v1.4.3.
More Skills