Simple Excel

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

Security Scan

The skill is internally consistent — it is an instruction-only guide for using pandas to read/write .xlsx and .csv files and it does not request extra permissions, credentials, or install any code.

Purpose & Capability

Name/description (simple Excel processing) matches the SKILL.md content, which contains pandas examples for reading, writing, and basic manipulation of .xlsx/.csv files. There are no unrelated requirements or capabilities requested.

Instruction Scope

SKILL.md contains only example Python/pandas snippets for file operations and basic transformations; it does not instruct the agent to read other system files, call external endpoints, or access credentials. Note: it implicitly assumes a Python environment with pandas (and potentially an Excel engine like openpyxl), but does not declare those dependencies.

Install Mechanism

No install spec and no code files — instruction-only. Nothing will be downloaded or written to disk by the skill itself.

Credentials

The skill requests no environment variables, credentials, or config paths. This is proportional to its stated purpose.

Persistence & Privilege

always is false and the default autonomous invocation setting is unchanged. The skill does not request permanent presence or modify other skills or system settings.

Assessment

This skill is a short how-to for using pandas to handle Excel/CSV files and does not require credentials or install anything. Before using: ensure your agent environment has Python and pandas (and an Excel engine such as openpyxl) if you want the examples to run; consider whether you trust any Excel files you open (avoid untrusted files — they can contain malicious content in other contexts, though pandas itself does not execute Excel macros). If you need guarantees about dependencies or reproducible installs, prefer a skill that declares its required packages or provides code that you can inspect and run in an isolated environment.

Simple Excel - 简化版 Excel 处理

快速开始

读取 Excel 文件

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 文件

import pandas as pd

# 保存为 xlsx
df.to_excel('output.xlsx', index=False)

# 保存为 csv
df.to_csv('output.csv', index=False)

简单数据处理

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 格式