CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

xlsx-skill

Excel / CSV(.xlsx / .xlsm / .csv / .tsv)读/写/统计/重算/图表一体化。触发场景:阅读单元格、汇总分组、谁最高谁最低、总收入、改单元格或公式、加行列、加合计行、插入图表(bar/line/pie)、冻结首行、加筛选、条件格式、CSV ↔ XLSX 互转、新建花名册/销售表/财务模型、排查 #REF!/#DIV/0! 公式错误、触发重算。典型说法:"这表里谁销量最高"、"Q1 总收入"、"把 B2 改成 500"、"加一行合计"、"新建花名册"、"csv 转 xlsx"、"冻结首行"、"A 列负数标红"。用户提到 .xlsx / .csv 文件或最终产出是表格都加载本技能。

68

Quality

86%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

65%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The body is a lean, highly actionable reference for the ExcelInspect/JsSandbox/DocConvert toolchain: executable exceljs code, a clear read-before-write sequence, and a practical pitfalls table. Its two structural weaknesses are the absence of any post-write validation checkpoint in destructive file-writing workflows and the monolithic single-file layout where several complete demos belong in one-level-deep reference files.

Suggestions

Add an explicit post-write verification step to the write workflow (e.g., 'after writeFile, re-run ExcelInspect(action="errors") or action="summary" to confirm the file is valid'), which would also lift the destructive-operation cap on workflow_clarity.

Split the secondary demos (2.3 chart embedding, 2.4 CSV conversion, 2.5 formula-error scanning) into references/ files (e.g., references/chart.md, references/convert.md, references/errors.md) and link them from short summary sections, keeping SKILL.md as a lean overview.

Include one concrete JsSandbox run example (parallel to the 'ExcelInspect { action: "summary", ... }' block) and show the chart generation step in demo 2.3 instead of assuming bar.png already exists.

DimensionReasoningScore

Conciseness

The body is efficient and assumes Claude's competence — no explanations of what Excel is or how libraries work; it opens with a tool table and dive straight into executable patterns like "读用 `ExcelInspect`;写 / 改 / 创建用 `JsSandbox`". Minor trimmable instances exist: comment lines like "// 表头" and "// 假设你已经用 chartjs-node-canvas 生成了 bar.png" assume state rather than instruct, and the ~210-line body carries five full demos where some (e.g., 2.3 chart embedding) serve narrower cases. This sits between anchor 4 ('Efficient; minor instances of over-explanation that could be trimmed') and 5; it is not 5 because not every token in the five inline demos earns an equal place, and not 3 because there is no genuinely unnecessary explanation.

4 / 5

Actionability

Guidance is mostly executable: concrete tool invocations ("ExcelInspect { action: 'summary', filePath: '…' }", "DocConvert(from='csv', to='xlsx', sourcePath='…')") and copy-paste-ready exceljs code for creation, conditional formatting, CSV conversion, and error scanning. Two gaps keep it from 5: the write path never shows a concrete `JsSandbox` run invocation (only the repair form "JsSandbox(action='edit-and-run', scriptPath=…, edits=[…])" at the end), and demo 2.3 depends on an unstated prerequisite ("假设你已经用 chartjs-node-canvas 生成了 bar.png") rather than a complete example. It is well above anchor 3 (pseudocode/missing key details) because the code itself is real and complete.

4 / 5

Workflow Clarity

The read-then-write sequence is clear (summary first, then values/formulas/style/errors, then JsSandbox writes, then conversion), and the pitfalls table provides symptom→cause→fix recovery rows (e.g., "打开提示'文件损坏' → 先 `ExcelInspect(errors)` 查"). However, the write/modify workflows are batch, destructive file operations and every demo ends at `writeFile` with no post-write verification checkpoint — validation is only reactive via the pitfalls table, never an explicit step. Per the rubric's cap ('Missing validation/verification steps in workflows involving destructive or batch operations should cap workflow clarity at 3'), 3 is the ceiling; it is above 2 because the sequence itself is well defined with a repair loop described.

3 / 5

Progressive Disclosure

Sections are well-labeled (工具清单, 读, 写 2.1–2.5, 格式互转, 常见陷阱) but no bundle files exist (no references/, scripts/, or assets/) and all ~210 lines — including five complete code demos — are inlined in SKILL.md. Content like the chart-embedding, CSV-conversion, and error-scanning demos is exactly the material the anchors place in separate reference files; this matches anchor 3 ('Some structure but could be better organized; ... content that should be separate is inline'). It is not 4 because a skill of this size with this much recipe-style code has real need for external reference files, and not 2 because the inline content is at least well-sectioned and navigable rather than a wall of text.

3 / 5

Total

14

/

20

Passed

Description

100%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

The description is exemplary: it states what the skill does through a comprehensive list of concrete operations, and when to load it through both an explicit trigger-scenario clause and quoted natural-language user phrasings, all anchored to specific file extensions. Distinctiveness from generic document or data skills is strong.

DimensionReasoningScore

Specificity

The description lists many concrete actions — "阅读单元格、汇总分组、谁最高谁最低、总收入、改单元格或公式、加行列、加合计行、插入图表(bar/line/pie)、冻结首行、加筛选、条件格式、CSV ↔ XLSX 互转、新建花名册/销售表/财务模型、排查 #REF!/#DIV/0! 公式错误、触发重算" — covering read, write, analysis, formatting, conversion, and error troubleshooting comprehensively. This matches the anchor 'Lists multiple specific concrete actions; comprehensive coverage'; a 4 would require minor coverage gaps, which are not evident.

5 / 5

Completeness

Both questions are answered explicitly: the "what" opens the description ("读/写/统计/重算/图表一体化" plus the enumerated operations) and the "when" is stated twice — a dedicated "触发场景:" clause and a closing "用户提到 .xlsx / .csv 文件或最终产出是表格都加载本技能". This matches the anchor 'Clearly and explicitly answers both what AND when with concrete trigger phrases'; a 4 would require the "when" to be less explicit, which it is not.

5 / 5

Trigger Term Quality

Natural user phrasings are quoted directly ("这表里谁销量最高", "Q1 总收入", "把 B2 改成 500", "加一行合计", "新建花名册", "csv 转 xlsx", "冻结首行", "A 列负数标红") alongside synonyms and file extensions (.xlsx / .xlsm / .csv / .tsv). This matches the anchor 'Comprehensive coverage of natural terms including synonyms and file extensions'; score 4 would mean a few natural terms are missing, but colloquial, technical, and extension forms are all present.

5 / 5

Distinctiveness Conflict Risk

The niche is clearly spreadsheet manipulation with distinct triggers — extension-specific file mentions and spreadsheet-only operations like "冻结首行", "加筛选", "条件格式", and "排查 #REF!/#DIV/0!" that no adjacent document/data skill would claim. This matches 'Clear niche with distinct triggers; minimal conflict risk'. It is not a 4 because the triggers are anchored to spreadsheet files and spreadsheet-exclusive features rather than merely 'closely related' domains.

5 / 5

Total

20

/

20

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

itsablabla/openloaf-web

Path

apps/server/src/ai/builtin-skills/xlsx/SKILL.md

Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.