利润表生成
v1.0.0根据明细表数据，自动生成规范格式利润表，收入支出按分类 2/3 分组动态汇总，含经营利润计算、固定格式和列宽。
⭐ 0· 60·0 current·0 all-time
byzen@courage-zen
MIT-0
Download zip
LicenseMIT-0 · Free to use, modify, and redistribute. No attribution required.
Security Scan
OpenClaw
Benign
medium confidencePurpose & Capability
The name/description (生成利润表) align with the provided Python implementation: it reads an Excel sheet named '明细', aggregates by 分类2/分类3, formats a new workbook, and writes an output file. The logic for income/expense selection matches the documented priority rules.
Instruction Scope
The SKILL.md and code stay within the stated purpose (reading a local Excel and writing a formatted workbook). However, the documentation uses hardcoded example paths under /Users/zhengyong/.openclaw/ and an example script path that does not match the included filename (SKILL.md suggests create_income_YYYYMM_simple.py but the repo contains generate_income_statement.py). These user-specific paths and filename mismatch are inconsistent and could cause confusion or accidental overwriting if used as-is.
Install Mechanism
There is no install spec (lowest disk risk). The code requires the openpyxl package but the skill does not declare dependencies or provide an install step; a runner would need to ensure openpyxl is available. No network downloads or external packages are pulled by the skill itself.
Credentials
The skill requests no environment variables or credentials. It does, however, read and write files under explicit user home paths in examples (~/ .openclaw/...), which is proportionate for a local report-generator but is user-specific and may unintentionally access other files if the pattern is used blindly.
Persistence & Privilege
always:false and no code attempts to modify other skills, agent settings, or persist credentials. The script writes only the output Excel file and prints a confirmation; it does not attempt network calls or background persistence.
Assessment
This skill appears to do what it says (generate a formatted profit & loss Excel from a '明细' sheet). Before installing or running: 1) Verify openpyxl is installed in the execution environment. 2) Inspect and, if needed, change the example hardcoded file paths (/Users/zhengyong/...) to safe, project-specific paths to avoid accidental overwriting of files in that user's home. 3) Note the SKILL.md script name differs from the included file (generate_income_statement.py) — call the actual filename or rename for clarity. 4) The code has minor bugs (e.g., month extraction iterates characters and may not yield the expected month); test on non-sensitive sample data first. 5) If you need stricter safety, adapt the script to accept explicit input/output paths and avoid implicit defaults pointing at any user's home directory.Like a lobster shell, security has layers — review code before you run it.
chinesevk970bpmr4gbgnbxr49rg7pqf6h840bnzexcelvk970bpmr4gbgnbxr49rg7pqf6h840bnzfinancevk970bpmr4gbgnbxr49rg7pqf6h840bnzlatestvk970bpmr4gbgnbxr49rg7pqf6h840bnz
License
MIT-0
Free to use, modify, and redistribute. No attribution required.