excel-parser

支持多种Excel格式的内容提取技能，使用calamine库处理.xls、.xlsx、.xlsm等格式。当用户需要解析Excel文件、提取表格数据、将Excel转换为文本格式、分析Excel内容或批量处理Excel文件时，务必使用此技能。适用于数据提取、报表分析、内容审核等场景。

Security Scan

The skill appears to implement exactly what it claims — a Python-based Excel parsing utility — with no obvious attempts to access unrelated secrets or external endpoints, but it will auto-install Python packages at runtime which has operational risk and requires internet access.

Purpose & Capability

Name, description, SKILL.md, requirements.txt and the Python code all align: this is an Excel parsing skill that uses python-calamine with xlrd/openpyxl as fallbacks. The code and declared dependencies are proportionate to the stated purpose.

Instruction Scope

SKILL.md and the code only describe reading user-supplied Excel files and optional .env settings (EXCEL_MAX_ROWS, EXCEL_KEEP_EMPTY_ROWS). The runtime code parses only the provided file paths and does not reference unrelated system paths or external endpoints. Note: the code calls load_dotenv() and will read .env if present (expected behavior).

Install Mechanism

There is no separate install spec, but the shipped Python script contains an install_dependency() helper that runs pip install via subprocess at runtime to fetch missing packages (e.g., python-calamine, xlrd). Using pip at runtime is a common convenience but increases risk because it performs network fetches and executes third-party package code; this is moderate risk but coherent with the skill's need for optional dependencies.

Credentials

The skill does not declare required environment variables or credentials in the registry. It documents optional .env keys for parser behavior (max rows, keep empty rows), which are reasonable and limited. No secrets, API keys, or unrelated env variables are requested.

Persistence & Privilege

always is false and the skill does not request elevated platform privileges. The only persistence-like behavior is installing Python packages into the runtime environment when dependencies are missing, which is expected but changes the environment; it does not modify other skills or system-wide agent settings.

Assessment

This skill looks consistent with its stated purpose, but be aware it will attempt to pip-install missing dependencies at runtime (internet access to PyPI is required). To reduce risk: run it in a sandboxed virtual environment, pin package versions, inspect the required packages (python-calamine, xlrd, openpyxl) before allowing installs, and verify the full script (including the truncated portion) if you need higher assurance. Also note the repository/homepage is unknown and setup.py lists version 1.0.0 while the registry metadata shows 2.0.0 — prefer obtaining packages from a trusted source (official PyPI/GitHub) before use.

Excel Parser Skill

Excel Parser技能用于从Excel文件中提取内容，支持多种Excel格式。

Compatibility

• Python 3.7+
• 依赖: python-dotenv, python-calamine
• 备选依赖: xlrd (用于.xls文件), openpyxl (用于.xlsx文件)

使用方法

基本使用

from excel_parser import ExcelParser, process_excel

# 方法1: 使用ExcelParser类
parser = ExcelParser()
result = parser.parse_excel('path/to/file.xlsx')

# 方法2: 使用便捷函数
result = process_excel('path/to/file.xlsx')

# 获取文本格式输出
text = parser.parse_excel_to_text('path/to/file.xlsx')

返回结果格式

{
    "text": "格式化的文本内容",
    "sheets": [
        {
            "name": "Sheet1",
            "rows": [["A1", "B1"], ["A2", "B2"]],
            "row_count": 2,
            "column_count": 2
        }
    ],
    "sheet_count": 1,
    "total_cells": 4,
    "engine": "python-calamine"
}

支持的文件格式

• .xls (Excel 97-2003)
• .xlsx, .xlsm (Excel 2007+)
• .xltx, .xltm (Excel模板)

环境变量配置

创建 .env 文件:

# 最大行数限制，默认100行
EXCEL_MAX_ROWS=100

# 是否保留空行，默认false
EXCEL_KEEP_EMPTY_ROWS=false

详细文档

更多使用示例和故障排除信息，参见 README.md。