Skip to content

PhilRobinluo/ai-coevolution-skills / skills/lls-local-excel-vba-data-processor

lls-local-excel-vba-data-processor

Verified

在数据不离开本机的前提下,设计、审查和交付 Excel VBA 数据处理方案。用于批量清洗、匹配、拆分、汇总、生成报表或处理敏感表格;必须先确认工作簿结构、备份与样例,再给出带中文注释、日志、异常处理、回滚和验收步骤的宏,不要求上传真实数据。

FileKindSize
README.mdmarkdown1.9 KB
SKILL.mdskill md8.0 KB
references/vba-safety-checklist.mdmarkdown913 B
# 罗老师 Excel VBA 本地数据处理

在数据不离开本机的前提下,把 Excel 清洗、匹配、拆分、汇总和报表工作做成可回滚、可验收的 VBA 方案。

- **当前源码版本:`1.2.0`**(最近 Release:`1.2.0`)
- 来源:🔵 LLS Original
- SkillHub:https://skillhub.cn/skills/lls-local-excel-vba-data-processor
- 飞书教程:https://m2wlgni9k4.feishu.cn/wiki/Gcc5wSTLhiTDMXkQLSUcYTI7nad
- GitHub Release:https://github.com/PhilRobinluo/ai-coevolution-skills/releases/tag/lls-local-excel-vba-data-processor-v1.2.0

## 启动语

```text
请用 lls-local-excel-vba-data-processor 帮我设计一个本地 Excel 宏。先问清表头、唯一键、重复规则和输出,再给代码、测试数据、回滚与验收步骤。真实数据不上传。
```

⭐ Star 用于收藏和支持;🔔 Watch Releases 用于接收更新;📦 Release 用于下载安装包。

## 在 WorkBuddy 安装

- **Skill slug:`lls-local-excel-vba-data-processor`**
- **SkillHub 状态:已发布**

把下面内容粘贴到 WorkBuddy 新会话:

```text
请按 https://skillhub.cn/install/skillhub.md 检查 SkillHub,搜索 `lls-local-excel-vba-data-processor`;仅在 slug 完全一致时安装到 `~/.workbuddy/skills/`。安装后读取 `~/.workbuddy/skills/lls-local-excel-vba-data-processor/SKILL.md`,核对 name、version 和实际路径,然后新开会话触发该 Skill。
```

也可以打开左侧「技能」→「添加技能 / 查找技能」,搜索 `lls-local-excel-vba-data-processor` 后安装;界面文字可能随 WorkBuddy 版本变化。

## 许可证与商业使用

本 Skill 的原创内容采用 [CC BY-NC-SA 4.0](../../LICENSES/CC-BY-NC-SA-4.0.txt)。企业内部普通办公可按[额外许可](../../ADDITIONAL-PERMISSIONS.md)免费使用;收费课程、转售、客户交付、SaaS、代运营等须取得[商业授权](../../COMMERCIAL-LICENSE.md)。
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 198kUpdated Claude CodeCodexVerifiedInstall