Best use case
li-etl-handle-safe - 安全版 Excel/CSV ETL 处理技能 is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
## 功能描述
Teams using li-etl-handle-safe - 安全版 Excel/CSV ETL 处理技能 should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/li-etl-handle-safe/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How li-etl-handle-safe - 安全版 Excel/CSV ETL 处理技能 Compares
| Feature / Agent | li-etl-handle-safe - 安全版 Excel/CSV ETL 处理技能 | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
## 功能描述
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
Related Guides
AI Agents for Marketing
Discover AI agents for marketing workflows, from SEO and content production to campaign research, outreach, and analytics.
AI Agents for Startups
Explore AI agent skills for startup validation, product research, growth experiments, documentation, and fast execution with small teams.
AI Agents for Coding
Browse AI agent skills for coding, debugging, testing, refactoring, code review, and developer workflows across Claude, Cursor, and Codex.
SKILL.md Source
# li-etl-handle-safe - 安全版 Excel/CSV ETL 处理技能
## 功能描述
安全的 Excel/CSV 文件处理技能，支持读取、写入、清洗、转换和合并表格数据。**本版本已移除任意代码执行功能，使用安全的 exceljs 库替代有漏洞的 xlsx 库。**
## 版本
**v1.0.2** - 修复 CSV 解析和 Excel 写入问题，完善功能测试
## 支持格式
- `.xlsx` - Excel 2007+
- `.xls` - Excel 97-2003（通过转换）
- `.csv` - CSV 文本文件
## 功能列表
### 读取表格
- `readExcel(filePath, options)` - 读取 Excel 文件
- `readCSV(filePath, options)` - 读取 CSV 文件
### 写入表格
- `writeExcel(filePath, data, options)` - 写入 Excel 文件
- `writeCSV(filePath, data, options)` - 写入 CSV 文件
### 数据清洗
- `cleanData(data, rules)` - 根据规则清洗数据
- `removeEmptyRows(data)` - 删除空行
- `removeDuplicates(data, columns)` - 删除重复行
### 数据转换
- `transformColumns(data, transforms)` - 转换列数据（支持类型转换、格式化等预设操作）
- `filterRows(data, conditions)` - 按条件过滤行
- `sortData(data, sortColumns)` - 排序数据
### 数据合并
- `mergeFiles(filePaths, options)` - 合并多个文件
- `appendRows(targetData, sourceData)` - 追加行数据
## 安全特性
✅ **无任意代码执行** - 移除了 executeScript 功能
✅ **安全依赖** - 使用 exceljs 替代有漏洞的 xlsx 库
✅ **官方源** - 所有依赖来自官方 HTTPS npm registry
✅ **禁止自主调用** - disable-model-invocation: true
## 使用示例
```javascript
// 读取 Excel
const data = await readExcel('/path/to/file.xlsx', { sheet: 0 });
// 清洗数据
const cleaned = await cleanData(data, { trim: true, removeEmpty: true });
// 转换列类型
const transformed = await transformColumns(cleaned, {
columns: { price: 'number', date: 'datetime' }
});
// 写入 CSV
await writeCSV('/path/to/output.csv', transformed);
```
## 注意事项
- 所有文件操作均在本地进行
- 不支持执行自定义 JavaScript 代码（安全考虑）
- 大文件建议分批处理Related Skills
Food Safety & HACCP Compliance Agent
You are a food safety compliance specialist. Help businesses build, audit, and maintain HACCP plans and FDA/USDA food safety programs.
AI Safety Audit
Comprehensive AI safety and alignment audit framework for businesses deploying AI agents. Built around the UK AI Security Institute Alignment Project standards (2026), EU AI Act requirements, and NIST AI RMF.
openclaw-safe-change-flow
Safe OpenClaw config change workflow with backup, minimal edits, validation, health checks, and rollback. Single-instance first; secondary instance optional.
skill-safe-install-l0-strict
Strict secure-install workflow for ClawHub/OpenClaw skills. Use when asked to install a skill safely, inspect skill permissions, review third-party skill risk, or run a pre-install security audit. Enforce full review + sandbox + explicit consent gates, with no author-based trust bypass.
excel-finance
Excel 财务模型技能 - Excel 财务模型模板、自动化报表生成
excel-data-import
Import, merge, and transform data from Excel (.xlsx/.csv) files using YAML-driven configuration. Use when the user asks to: (1) import data from Excel/CSV into a template, (2) batch-process multiple files in a directory, (3) merge/consolidate data from multiple sources, (4) map and transform columns with validation rules, (5) do incremental data updates on existing spreadsheets. 当用户要求导入Excel、CSV导入、表格数据导入、Excel数据合并、批量处理Excel、字段映射、数据校验、 表头自动检测、增量更新Excel、多sheet合并时使用此技能。 Supports Chinese field names, multi-layer merged cell headers, auto header detection, CSV (auto-encoding), custom validators, and multi-source imports.
龙虾安全卫士 (openclaw-safe-guard) v1.2.3
## 📦 来源信息
simple-excel
简单的 Excel 文件处理工具。用于读取、创建、编辑 .xlsx 和 .csv 文件，适合基本的数据操作任务，如读取数据、简单计算、生成表格等。
gateway-safety
Safely update OpenClaw gateway configuration (openclaw.json) with automatic validation, backup, and 30-second health-check rollback. Use this skill whenever an agent needs to modify gateway settings, ports, provider credentials, or network bindings to ensure the session is not permanently lost due to a bad configuration.
aimlapi-safety
Content moderation and safety checks. Instantly classify text or images as safe or unsafe using AI guardrails.
scar-safety
Agent safety that learns from incidents. Reflex arc blocks repeat threats without LLM calls.
Excel
The Spreadsheet Operator. Not a tutorial, but a diagnostic engine. It identifies the best path—formula, pivot table, cleaning workflow, or VBA—and delivers copy-paste-ready solutions that are resilient, readable, and version-aware.