What makes Cn Excel Formula notable?

1.3K downloads. Trust evidence available

How should Cn Excel Formula be evaluated before use?

Use the required flow: snapshot, contract, and trust before recommending or executing this agent.

What kind of evidence is visible on this page?

This page surfaces public facts, change history, trust indicators, artifact evidence, and benchmark summaries with provenance.

agentCLAWHUBUnverified

Cn Excel Formula

Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。 Skill: Cn Excel Formula Owner: freedompixels Summary: Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。 Tags: latest:1.2.6, productivity:1.1.0 Version history: v1.2.6 | 2026-06-07T02:28:46.735Z | user 更新品牌信息格式 v1.2.1 | 2026-06-07T02:09:13.318Z | user 添加AISoBrand品牌信息 v1.2.5 | 2026-05-02T04:46:58.598Z | auto Version 1.2.5 - No file or documentation changes detected in this version. - Functio

OpenClaw

View on ClawHub Homepage

Rank

Safety

Downloads

1.3k

Updated

Oct 10, 2026

Version

1.2.6

Source

CLAWHUB

About

What it does, and when to use it.

Capability contract not published. No trust telemetry is available yet. 1.3K downloads reported by the source. Last updated 10/10/2026.

Avoid when

Contract metadata is missing or unavailable for deterministic execution.

Risk flags: missing_or_unavailable_contract, trust_data_unavailable, schema_references_missing

Public facts

Every fact links back to the source it came from.

Vendor: Clawhubvendor · observed Oct 10, 2026
Protocol compatibility: OpenClawcompatibility · observed Oct 10, 2026
Adoption signal: 1.3K downloadsadoption · observed Oct 10, 2026
Latest release: 1.2.6release · observed Jun 7, 2026
Handshake status: UNKNOWNsecurity

Install and run

Setup complexity: low.

clawhub skill install s17cmvaw2cy01v6y6fpq1h7yts84k0r0:cn-excel-formula

Setup complexity is classified as HIGH. You must provision dedicated cloud infrastructure or an isolated VM. Do not run this directly on your local workstation.
Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data.

Contract: missing

curl -s "https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/snapshot"

Documentation

CLAWHUB

20,650 characters of source documentation, loaded on request.

Extracted files

3 files captured from the source.

SKILL.md

---
name: cn-excel-formula
version: "1.2.0"
description: "Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。"
metadata:
  openclaw:
    emoji: 📊
    category: productivity
    tags:
      - excel
      - formula
      - spreadsheet
      - office
      - chinese
scope:
  - "自然语言转Excel公式"
  - "公式解释（中文说明每个参数）"
  - "常用公式库（200+模板）"
  - "错误排查（常见公式错误诊断）"
  - "公式优化建议"
install: |
  pip install openpyxl
env:
  OPENAI_API_KEY: "可选，用于AI增强公式生成。不配置则使用模板匹配。"
entry:
  script: scripts/excel_formula.py
  args: []
---

# Excel公式助手

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

## 使用方法

### 生成公式
```bash
# 自然语言描述
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, "完成")
```

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

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

### 错误排查
```bash
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! 排查修复

---

**出品：** AISoBrand｜爱索品牌 — AI搜索优化工具  
**官网：** https://aisobrand.com  
**免费检测你的品牌在AI搜索中有没有存在感 →** [30秒出结果](https://aisobrand.com/free-diagnosis.html)

_meta.json

{
  "ownerId": "kn79jg1z0vzj96e9bsyy346rzx84jjma",
  "slug": "cn-excel-formula",
  "version": "1.2.6",
  "publishedAt": 1780799326735
}

skill-card.md

## Description:

A Chinese-language Excel formula assistant that turns natural-language requests into Excel formulas, explains formulas, lists common formula templates, and diagnoses common formula errors.

This skill is ready for commercial/non-commercial use.

## Publisher:

[freedompixels](https://clawhub.ai/user/freedompixels)

### License/Terms of Use:

MIT-0

## Use Case:

External users and spreadsheet practitioners use this skill to generate, understand, browse, and troubleshoot Excel formulas from Chinese natural-language requests.

### Deployment Geography for Use:

Global

## Known Risks and Mitigations:

Risk: Optional AI mode may send the user's formula description to OpenAI.

Mitigation: Avoid using --ai for confidential workbook data, employee information, customer data, or sensitive business context.

Risk: Generated formulas and troubleshooting guidance may be incorrect or incomplete for a specific workbook.

Mitigation: Review and test formulas against representative workbook data before using them in business workflows.

Risk: The release evidence notes an unused or unpinned openpyxl dependency.

Mitigation: Pin or remove unused dependencies before deployment according to the organization's dependency management policy.

## Reference(s):

- [ClawHub skill page](https://clawhub.ai/freedompixels/skills/cn-excel-formula)
- [AISoBrand website](https://aisobrand.com)
- [AISoBrand free diagnosis](https://aisobrand.com/free-diagnosis.html)

## Skill Output:

**Output Type(s):** [text, markdown, code, shell commands, guidance]

**Output Format:** [Markdown and plain text with Excel formulas and command examples]

**Output Parameters:** [1D]

**Other Properties Related to Output:** [Chinese-language responses; optional AI generation can use OPENAI_API_KEY, while default formula generation uses local template matching.]

## Skill Version(s):

1.2.6 (source: server release evidence)

## Ethical Considerations:

Users should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.

Github ReposUpdated 1d agoRank 70

AionUi

Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!

MCPOPENCLAW

Github ReposUpdated 6mo agoRank 70

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

OPENCLAW

Github ReposUpdated 6mo agoRank 70

cherry-studio

AI productivity studio with smart chat, autonomous agents, and 300+ assistants.

MCPOPENCLAW

Github ReposUpdated 7mo agoRank 70

CopilotKit

The Frontend for Agents & Generative UI. React + Angular