PhilRobinluo/ai-coevolution-skills / skills/lls-local-excel-vba-data-processor
lls-local-excel-vba-data-processor
Verified在数据不离开本机的前提下,设计、审查和交付 Excel VBA 数据处理方案。用于批量清洗、匹配、拆分、汇总、生成报表或处理敏感表格;必须先确认工作簿结构、备份与样例,再给出带中文注释、日志、异常处理、回滚和验收步骤的宏,不要求上传真实数据。
| File | Kind | Size |
|---|---|---|
| README.md | markdown | 1.9 KB |
| SKILL.md | skill md | 8.0 KB |
| references/vba-safety-checklist.md | markdown | 913 B |
references/vba-safety-checklist.md
View on GitHub# Excel VBA 本地处理安全清单
## 发布前代码检查
- `Option Explicit`
- 没有硬编码真实用户名和绝对路径
- 没有 `Shell`、PowerShell、网络请求或自动发信
- 没有删除原始工作表
- 没有静默覆盖同名文件
- 成功与失败都恢复 Excel 状态
- 输入范围、表头和工作表均有检查
- 错误信息包含步骤,不输出敏感数据
## 最小验收表
| 测试 | 输入 | 期望 |
|---|---|---|
| 正常 | 三条合法记录 | 三条成功 |
| 空值 | 唯一键为空 | 进入错误清单 |
| 重复 | 两条相同唯一键 | 按数据契约处理 |
| 格式错 | 非法日期/金额 | 不写入正式结果 |
| 无匹配 | 查找表中不存在 | 标记未匹配 |
## 回滚
1. 关闭当前测试副本;
2. 保留日志和错误清单;
3. 从运行前备份重新复制一份;
4. 修正规则或宏;
5. 用同一组测试案例复测。
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| canvas-designanthropics/skillsCreate beautiful visual art in .png and .pdf documents using design philosophy. You should use this skill when the user asks to create a poster, piece of art, design, or other static piece. Create original visual designs, never copying existing artists' work to avoid copyright violations. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| docxanthropics/skillsUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files) or Word templates (.dotx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', '.dotx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx or .dotx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| pdfanthropics/skillsUse this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| pptxanthropics/skillsUse this skill any time a .pptx or .potx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx or .potx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates (.potx), layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx or .potx filename, regardless of what they plan to do with the content afterward. If a .pptx or .potx file needs to be opened, created, or touched, use this skill. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |