simple-excel

简单的 Excel 文件处理工具。用于读取、创建、编辑 .xlsx 和 .csv 文件，适合基本的数据操作任务，如读取数据、简单计算、生成表格等。

View Source SKILL.md

Stars

Installs

Status

ACTIVE

Visibility

PUBLIC

安装方式

直接复制以下提示词，发送给你的 AI 助手即可完成安装。

请先检查是否已安装 SkillHub 商店，若未安装，请根据 https://skillhub-1388575217.cos.ap-guangzhou.myqcloud.com/install/skillhub.md 安装 SkillHub 商店，然后安装 simple-excel 技能。若已安装，则直接安装 simple-excel 技能。

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

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

★ 0

Task Router

capncoconut

x402hub

★ 0

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

★ 0

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

★ 0

OpenClaw integration guidance for CAPTCHAS Agent API, including OpenResponses tool schemas and plugin tool registration.

carol-gutianle

Modelready

★ 0

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

★ 0

Controls Wiz smart bulbs (turn on/off, RGB colors, disco mode) via local WiFi.

Analysis Signals

Dependencies

python