Overview
- Skill Key
- anmu14641/simple-excel
- Author
- anmu14641
- Source Repo
- openclaw/skills
- Version
- 1.0.0
- Source Path
- skills/anmu14641/simple-excel
- Latest Commit SHA
- a4cffde08706591b65da33e67547ae77d0022f3e
Official OpenClaw
rules
15%
simple-excel
简单的 Excel 文件处理工具。用于读取、创建、编辑 .xlsx 和 .csv 文件，适合基本的数据操作任务，如读取数据、简单计算、生成表格等。
Stars
0
Installs
0
Status
ACTIVE
Visibility
PUBLIC
安装方式
直接复制以下提示词，发送给你的 AI 助手即可完成安装。
请先检查是否已安装 SkillHub 商店，若未安装，请根据 https://skillhub-1388575217.cos.ap-guangzhou.myqcloud.com/install/skillhub.md 安装 SkillHub 商店，然后安装 simple-excel 技能。 若已安装，则直接安装 simple-excel 技能。
Extracted Content
SKILL.md excerpt
# Simple Excel - 简化版 Excel 处理
## 快速开始
### 读取 Excel 文件
```python
import pandas as pd
# 读取 xlsx 或 csv
df = pd.read_excel('file.xlsx')
df = pd.read_csv('file.csv')
# 读取指定sheet
df = pd.read_excel('file.xlsx', sheet_name='Sheet1')
```
### 写入 Excel 文件
```python
import pandas as pd
# 保存为 xlsx
df.to_excel('output.xlsx', index=False)
# 保存为 csv
df.to_csv('output.csv', index=False)
```
### 简单数据处理
```python
import pandas as pd
# 筛选数据
df[df['列名'] > 10]
# 添加新列
df['新列'] = df['列1'] + df['列2']
# 分组统计
df.groupby('类别').sum()
# 排序
df.sort_values('金额', ascending=False)
```
## 常用操作
| 操作 | 代码 |
|------|------|
| 查看前几行 | `df.head()` |
| 查看数据类型 | `df.dtypes` |
| 统计摘要 | `df.describe()` |
| 选择列 | `df[['列A', '列B']]` |
| 筛选行 | `df[df['列'] > 100]` |
| 删除列 | `df.drop('列名', axis=1)` |
| 重命名列 | `df.rename(columns={'旧名': '新名'})` |
| 填充空值 | `df.fillna(0)` |
| 导出指定sheet | `df.to_excel('file.xlsx', sheet_name='新sheet')` |
## 注意事项
- 使用 `index=False` 避免导出索引列
- 中文字符在 Excel 中通常能正常显示
- 大文件建议使用 csv 格式
Related Claw Skills
capt-marbles
Task Router Skill
Task Router
capncoconut
x402hub
Register, communicate, and earn on the x402hub AI agent marketplace. Use when an agent needs to register on x402hub, browse or claim bounties, submit deliverables, send messages to other agents via x402 Relay, check marketplace stats, or manage agent credentials. Triggers on x402hub, agent marketplace, bounty, relay messaging, agent-to-agent communication, or USDC earning.
capevace
claw
Real-time event bus for AI agents. Publish, subscribe, and share live signals across a network of agents with Unix-style simplicity.
captchasco
captchas-openclaw
OpenClaw integration guidance for CAPTCHAS Agent API, including OpenResponses tool schemas and plugin tool registration.
carol-gutianle
Modelready
name: modelready description: Start using a local or Hugging Face model instantly, directly from chat. metadata: {"openclaw":{"requires":{"bins": "bash", "curl" }, "env": "URL" }}
canbirlik
wiz-light-control
Controls Wiz smart bulbs (turn on/off, RGB colors, disco mode) via local WiFi.