xlsx

xlsx is a skill for Claude Code, Codex from liyecom/liye-ai. It costs 12 tokens per session (934 once invoked), scanned A, original, Apache-2.0.

A toolkit for creating, editing, and analysing spreadsheet files such as Excel workbooks and CSV files. It supports formulas, formatting, multiple worksheets, charts, and data operations.

In plain words
What is it for?
Reading and modifying Excel or delimited files, creating reports, recalculating formulas, combining data sources, filtering and sorting data, and making charts.
Why use it?
It avoids manually changing spreadsheet data and presentation, and helps preserve formulas and structure while analysing or combining files.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one. Also seen: reads .claude/ paths.

Good fit Reading and modifying Excel or delimited files, creating reports, recalculating formulas, combining data sources, filtering and sorting data, and making charts.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/liyecom/liye-ai/xlsx
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add liyecom/liye-ai --skill xlsx
Clone the repo
git clone --depth 1 https://github.com/liyecom/liye-ai

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for xlsx

README.md
[![agentmods](https://agentmods.dev/badge/skills/liyecom/liye-ai/xlsx/github.svg)](https://agentmods.dev/skills/liyecom/liye-ai/xlsx)
Your own site
<a href="https://agentmods.dev/skills/liyecom/liye-ai/xlsx"><img src="https://agentmods.dev/badge/skills/liyecom/liye-ai/xlsx/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for xlsx

Your own site · 80×15
<a href="https://agentmods.dev/skills/liyecom/liye-ai/xlsx"><img src="https://agentmods.dev/badge/skills/liyecom/liye-ai/xlsx.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 12 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 934 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00012 $0.00934
Opus 5 $0.00006 $0.00467
Sonnet 5 $0.00002 $0.00187
Haiku 4.5 $0.00001 $0.00093

Measured 10d ago against content hash cb58f1bbcb08, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-09, from the pricing page.

Security

Grade A, and why

xlsx scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 10d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Skills/00_Core_Utilities/document-processing/xlsx/SKILL.md · 118 lines

What it actually says

xlsx

来源: ComposioHQ/awesome-claude-skills 适配: LiYe OS 三层架构

综合电子表格操作工具,支持创建、编辑、分析 Excel 文件,包括公式、图表、数据转换等完整功能。

When to Use This Skill

当 Claude 需要处理电子表格文件时:

  • 创建新的电子表格并填充数据
  • 读取或分析现有的 .xlsx, .xlsm, .csv, .tsv 文件
  • 修改现有电子表格并保留公式
  • 执行数据分析和可视化
  • 重新计算公式

Core Capabilities

1. 文件读写

  • 支持 .xlsx, .xlsm, .csv, .tsv 格式
  • 保留原有公式和格式
  • 处理多工作表工作簿

2. 公式与计算

  • 创建和编辑公式
  • 支持常用函数 (SUM, AVERAGE, VLOOKUP, IF 等)
  • 公式重新计算

3. 数据可视化

  • 创建图表 (柱状图、折线图、饼图等)
  • 条件格式化
  • 数据透视表

4. 格式化

  • 单元格样式 (字体、颜色、边框)
  • 数字格式 (货币、百分比、日期)
  • 列宽行高调整

5. 数据分析

  • 数据筛选和排序
  • 统计分析
  • 数据验证

Usage Examples

示例 1: 读取并分析销售数据

用户: 分析这个 Amazon 销售报表的趋势
Claude: [使用 xlsx 技能读取文件,提取数据,生成趋势分析]

示例 2: 创建关键词矩阵

用户: 帮我创建一个关键词研究矩阵表格
Claude: [使用 xlsx 技能创建结构化表格,添加公式计算搜索量权重]

示例 3: 合并多个数据源

用户: 把这三个 CSV 文件合并成一个 Excel 报表
Claude: [使用 xlsx 技能读取多个文件,合并数据,生成格式化报表]

Dependencies

  • Python: openpyxl, pandas, xlsxwriter
  • 或 Node.js: xlsx, exceljs

LiYe OS Integration

业务域引用

此技能被以下业务域引用:

  • 02_Operation_Intelligence: Amazon 销售/关键词/PPC 报表分析
  • 07_Data_Science: 通用数据分析
  • 04_Business_Operations: 商务报表处理

三层架构位置

  • 物理层 (本文件): Skills/00_Core_Utilities/document-processing/xlsx/
  • 逻辑层索引: Skills/{domain}/index.yaml
  • L3 指令层: .claude/skills/{domain}/xlsx/

Created: 2025-12-28 | Adapted for LiYe OS

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 10d ago First seen · 118 lines · 12 tokens per session scan A cb58f1bbcb08

Subscribe to this mod's changes

xlsx is a skill published in the GitHub repository liyecom/liye-ai (33 stars, last pushed 2d ago), licensed Apache-2.0. It adds 12 tokens to every session and 934 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

sn-da-excel-workflow

A step-by-step workflow for analysing Excel workbooks with multiple sheets. It covers reading data, cleaning it, filtering and combining results, and exporting reports, with a separate strategy for large files.

OpenSenseNova/SenseNova-Skills · 348 tokens

sn-da-large-file-analysis

A workflow for analyzing very large Excel datasets, especially files with at least 10,000 rows. It uses lower-memory reading, streaming through rows, splitting work into chunks, and converting data to Parquet, a column-based data format suited to repeated analysis.

OpenSenseNova/SenseNova-Skills · 218 tokens

category-filtering-and-difficulty-analysis

A workflow for grouping Excel records into categories and analyzing them across several measures, including text length and terminology density.

OpenSenseNova/SenseNova-Skills · 74 tokens

multi-sheet-reading-and-analysis

A workflow for reading and analyzing Excel files with multiple worksheets, including data cleaning, grouping, fitting lines to data, and formatted charts.

OpenSenseNova/SenseNova-Skills · 53 tokens

excel-multi-sheet-dynamic-analysis

A workflow for analyzing Excel workbooks with multiple sheets by finding relevant headers and fields, cleaning data, comparing sheets, and creating visual summaries.

OpenSenseNova/SenseNova-Skills · 65 tokens

excel-data-analysis-and-report-generation

A skill for extracting, categorising, counting, and comparing data from Excel spreadsheets. It can produce summary tables with totals, percentages, and cross-tabulations.

OpenSenseNova/SenseNova-Skills · 30 tokens