Excel公式助手

Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。

Security Scan

The skill is internally consistent with its stated purpose (generating and explaining Excel formulas); it only optionally uses the OpenAI API (if you provide a key) and otherwise relies on a local template library—no unrelated credentials, strange install sources, or unexpected persistence were found in the provided files.

Purpose & Capability

Name/description (Excel formula generation, explanation, templates, diagnosis) matches the shipped assets: a templates dictionary, NL→formula rules, CLI examples, and an optional AI path. The only minor mismatch is that SKILL.md suggests installing openpyxl even though the visible code primarily performs text-based generation (openpyxl may be used elsewhere in the file but is plausible for Excel-related helpers).

Instruction Scope

SKILL.md instructs running the included script with generate/explain/list/diagnose commands. The instructions do not ask the agent to read unrelated system files or secret locations. The script attempts to read only OPENAI_API_KEY from the environment when AI generation is enabled.

Install Mechanism

There is no registry install spec; SKILL.md suggests 'pip install openpyxl' which is a standard package on PyPI. No downloads from untrusted URLs or archive extraction were observed.

Credentials

The skill does not require any credentials. It documents an optional OPENAI_API_KEY for enhanced AI generation, which is proportional to the optional OpenAI usage in the code. No other secrets or unrelated environment variables are requested.

Persistence & Privilege

Skill is not forced-always, does not request autonomy-related privileges beyond the platform defaults, and does not appear to modify other skills or system-wide configurations.

Assessment

This skill appears to be what it says: a Chinese Excel formula helper using a local template library with optional OpenAI assistance. Before installing, consider: 1) The script will call OpenAI only if you install the openai package and set OPENAI_API_KEY—don't set that key unless you trust using the OpenAI service. 2) openpyxl is suggested but may not be strictly necessary; installing it is low-risk from PyPI but you can inspect the full script to confirm why it's used. 3) If you need to be extra cautious, run the script in an isolated environment (virtualenv/container) and review the full, untruncated source to ensure there are no hidden network calls or file-access behaviors beyond what was reviewed. If you want, I can scan the remainder of the script (the provided content was truncated) to raise confidence.

功能

• 自然语言描述 → 自动生成Excel公式
• 公式中文解释（每个参数都有说明）
• 200+常用公式模板库
• 常见错误排查
• 公式优化建议

使用方法

生成公式

# 自然语言描述
python scripts/excel_formula.py generate "查找A列中与D2匹配的B列值"
# 输出：=VLOOKUP(D2, A:B, 2, FALSE)

# 带条件的求和
python scripts/excel_formula.py generate "求A列大于100且B列为'完成'的C列之和"
# 输出：=SUMIFS(C:C, A:A, ">100", B:B, "完成")

解释公式

python scripts/excel_formula.py explain "=VLOOKUP(D2,A:B,2,FALSE)"
# 输出中文解释

常用公式库

# 列出某类别公式
python scripts/excel_formula.py list --category lookup
python scripts/excel_formula.py list --category date
python scripts/excel_formula.py list --category text

错误排查

python scripts/excel_formula.py diagnose "=VLOOKUP(D2,A:B,2,FALSE)" --error "#N/A"
# 输出可能原因和修复方法

支持的公式类别

类别	常用公式
查找引用	VLOOKUP, HLOOKUP, INDEX+MATCH, XLOOKUP, INDIRECT
条件统计	SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS
日期时间	DATE, DATEDIF, EDATE, EOMONTH, NETWORKDAYS
文本处理	LEFT, RIGHT, MID, FIND, SUBSTITUTE, CONCATENATE
逻辑判断	IF, IFS, SWITCH, AND, OR, IFERROR
数学计算	ROUND, ROUNDUP, ROUNDDOWN, MOD, INT, ABS
数据清洗	TRIM, CLEAN, UPPER, LOWER, PROPER, TEXT
数组公式	UNIQUE, FILTER, SORT, SEQUENCE, TRANSPOSE

典型场景

1. 数据查找：根据姓名查工资、根据编号查详情
2. 条件汇总：按部门/月份/状态分类统计
3. 日期计算：工龄、合同到期、项目倒计时
4. 文本提取：从身份证提取生日、提取邮箱域名
5. 错误处理：#N/A、#VALUE!、#REF! 排查修复