acefrost511/xlsx
skills/xlsx/SKILL.md
Create, edit, analyze spreadsheets (.xlsx, .xlsm, .csv). Formulas, formatting, data analysis.
development
Updated Apr 3, 2026
$ install --global
skillsauthnpx skillsauth add acefrost511/workmemory xlsxInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 3, 2026, 9:50 PM105.8s1 file scanned
SKILL.md
- name:
- xlsx
- description:
- Create, edit, analyze spreadsheets (.xlsx, .xlsm, .csv). Formulas, formatting, data analysis.
xlsx
功能
创建、编辑、分析电子表格
触发条件
- 处理 .xlsx、.xlsm、.csv、.tsv
- 创建带公式和格式的表格
- 数据分析和可视化
零公式错误
所有Excel文件必须零错误：#REF!、#DIV/0!、#VALUE!、#N/A、#NAME?
颜色编码（财务模型）
- 蓝色：硬编码输入
- 黑色：公式
- 绿色：同工作表链接
- 红色：外部链接
- 黄色背景：关键假设
数字格式
- 年份：用文本 "2024"
- 货币：$#,##0，标题写单位
- 零：显示 "-"
- 负数：括号 (123)
用公式，不用硬编码
# ❌ 错误：硬编码
sheet['B10'] = 5000
# ✅ 正确：用公式
sheet['B10'] = '=SUM(A1:A10)'
pandas（数据分析）
import pandas as pd
df = pd.read_excel('file.xlsx')
df.to_excel('output.xlsx', index=False)
openpyxl（公式+格式）
from openpyxl import Workbook
wb = Workbook()
sheet = wb.active
sheet['A1'] = '=SUM(B1:B10)'
wb.save('output.xlsx')
公式重算（必须）
python recalc.py output.xlsx
验证检查
- 测试2-3个样本引用
- 检查列映射（列64=BL）
- 行偏移（DataFrame行5=Excel行6）
- 除零检查
Related Skills
acefrost511/self-improving-agent
testing
VerifiedTrustedCommunity
Self-improving agent system that analyzes conversation quality, identifies improvement opportunities, and continuously optimizes response strategies.
SKILL.mdUpdated Apr 3, 2026
acefrost511/using-superpowers
tools
VerifiedTrustedCommunity
Use when starting any conversation - establishes how to find and use skills, requiring Skill tool invocation before ANY response including clarifying questions
SKILL.mdUpdated Apr 3, 2026
acefrost511/topic-to-article-kit
documentation
VerifiedTrustedCommunity
Turn a chosen AI topic into a public-account writing package: collect evidence from X/Twitter and other sources, extract high-value comments, and produce title options + structured outline written into Obsidian. Use when user asks for topic-based research and article prep.
SKILL.mdUpdated Apr 3, 2026
acefrost511/task-review-workflow
development
VerifiedTrustedCommunity
Standard PR review and merge workflow for task-driven development. Use when reviewing a programmer agent PR linked to a task, deciding merge vs change request, handling post-merge actions (Trello + branch cleanup), and sending a clear outcome handoff.
SKILL.mdUpdated Apr 3, 2026