← 返回 Skills 市场
1605
总下载
1
收藏
2
当前安装
1
版本数
在 OpenClaw 中安装
/install retail-trade-report-generator
功能描述
Generates a consolidated weekly retail trade report by processing 12 Excel sales files, mapping stores to regions, calculating ADA metrics, WoW comparisons,...
安全使用建议
This package looks coherent and not malicious, but take these practical steps before running it: 1) Review the Python code yourself (or have a developer do so) to confirm the column/row indices and sheet names match your real Excel exports — the script uses hard-coded row ranges and sheet names which may need adjustment. 2) Run it in a controlled environment (local VM or container) and install dependencies from official sources (pip install pandas openpyxl). 3) Provide only the intended input files and the store_mapping.csv; the skill reads only files in the specified input directory and writes an output Excel. 4) Test with sample data to verify results and edge-case handling (e.g., missing sheets, date parsing). If you need the skill to run autonomously on a platform, ensure the runtime includes the required Python packages or add an install step that pins trusted package versions.
功能分析
Type: OpenClaw Skill
Name: retail-trade-report-generator
Version: 1.0.0
The skill bundle is classified as benign. The `SKILL.md` documentation clearly outlines the purpose and functionality, providing instructions for an AI agent that are aligned with data processing and report generation without any signs of prompt injection or malicious intent. The Python script `scripts/retail_trade_report_generator.py` uses standard libraries (`pandas`, `openpyxl`, `re`, `os`, `datetime`) for reading specified Excel and CSV files from an input directory and writing a consolidated Excel report to an output directory. There is no evidence of data exfiltration, malicious execution (e.g., `eval`, `subprocess`, network calls), persistence mechanisms, or obfuscation. All file operations are confined to expected user-data paths.
能力评估
Purpose & Capability
The SKILL.md, README, and the included Python script all align: they expect 12 Excel files plus a store_mapping.csv and produce a consolidated Excel report. One minor mismatch: the package metadata declares no required binaries or env vars, but the provided code requires a Python runtime with pandas and openpyxl; those dependencies are not declared in the skill metadata or install spec.
Instruction Scope
Runtime instructions and the code limit actions to reading local Excel files and a CSV, aggregating numbers, and writing an Excel output. There are no instructions to read unrelated system files, environment variables, or to send data to external endpoints.
Install Mechanism
There is no install spec (instruction-only), which minimizes install-time risk. However, the shipped Python script requires third-party libraries (pandas, openpyxl) that are not declared; the skill does not provide an install step or pinned package list. This is an operational omission rather than a security red flag, but you should ensure dependencies are installed from trusted sources before running.
Credentials
The skill requests no environment variables, no credentials, and no config paths. Required inputs are explicit (local Excel files and a mapping CSV) and proportional to the stated purpose.
Persistence & Privilege
The skill is not forced always-on and does not request persistent platform privileges. It does not modify other skills or system-wide settings in the provided code.
如何使用
- 确保已安装 OpenClaw(本地或 Docker 部署)
- 在对话框中输入安装命令:
/install retail-trade-report-generator - 安装完成后,直接呼叫该 Skill 的名称或使用
/retail-trade-report-generator触发 - 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
Retail Trade Weekly Report Generator 1.0.0
- Initial release.
- Consolidates 12 weekly sales Excel files into a comprehensive Retail Trade Weekly Report with channel, region, and product breakdown.
- Calculates Average Daily Acquisition (ADA) and Week-over-Week (WoW) performance.
- Uses detailed mapping rules to aggregate data by standard regions, handling fuzzy store name matching.
- Outputs a formatted Excel workbook with styled summary tables and three embedded charts.
- Includes robust error handling for missing or mismatched input files.
元数据
常见问题
retail-trade-report-generator 是什么?
Generates a consolidated weekly retail trade report by processing 12 Excel sales files, mapping stores to regions, calculating ADA metrics, WoW comparisons,... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 1605 次。
如何安装 retail-trade-report-generator?
在 OpenClaw 或 Claude Code 对话框中运行命令「/install retail-trade-report-generator」即可一键安装,无需额外配置。
retail-trade-report-generator 是免费的吗?
是的,retail-trade-report-generator 完全免费(开源免费),可自由下载、安装和使用。
retail-trade-report-generator 支持哪些平台?
retail-trade-report-generator 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。
谁开发了 retail-trade-report-generator?
由 wuminmin(@wuminmin)开发并维护,当前版本 v1.0.0。
推荐 Skills