Back to Details

xlsx

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

xlsx

xlsx

来源: ComposioHQ/awesome-claude-skills 适配: LiYe OS 三层架构
综合电子表格操作工具，支持创建、编辑、分析 Excel 文件，包括公式、图表、数据转换等完整功能。
Source: ComposioHQ/awesome-claude-skills Adapted for: LiYe OS Three-tier Architecture
Comprehensive spreadsheet manipulation tool that supports creating, editing, and analyzing Excel files, with full features including formulas, charts, data conversion, etc.

When to Use This Skill

When to Use This Skill

当 Claude 需要处理电子表格文件时：
  • 创建新的电子表格并填充数据
  • 读取或分析现有的 .xlsx, .xlsm, .csv, .tsv 文件
  • 修改现有电子表格并保留公式
  • 执行数据分析和可视化
  • 重新计算公式
When Claude needs to handle spreadsheet files:
  • Create new spreadsheets and populate data
  • Read or analyze existing .xlsx, .xlsm, .csv, .tsv files
  • Modify existing spreadsheets while preserving formulas
  • Perform data analysis and visualization
  • Recalculate formulas

Core Capabilities

Core Capabilities

1. 文件读写

1. File Reading and Writing

  • 支持 .xlsx, .xlsm, .csv, .tsv 格式
  • 保留原有公式和格式
  • 处理多工作表工作簿
  • Supports .xlsx, .xlsm, .csv, .tsv formats
  • Preserves original formulas and formatting
  • Handles multi-sheet workbooks

2. 公式与计算

2. Formulas and Calculations

  • 创建和编辑公式
  • 支持常用函数 (SUM, AVERAGE, VLOOKUP, IF 等)
  • 公式重新计算
  • Create and edit formulas
  • Supports common functions (SUM, AVERAGE, VLOOKUP, IF, etc.)
  • Formula recalculation

3. 数据可视化

3. Data Visualization

  • 创建图表 (柱状图、折线图、饼图等)
  • 条件格式化
  • 数据透视表
  • Create charts (bar charts, line charts, pie charts, etc.)
  • Conditional formatting
  • Pivot tables

4. 格式化

4. Formatting

  • 单元格样式 (字体、颜色、边框)
  • 数字格式 (货币、百分比、日期)
  • 列宽行高调整
  • Cell styles (font, color, borders)
  • Number formats (currency, percentage, date)
  • Adjust column width and row height

5. 数据分析

5. Data Analysis

  • 数据筛选和排序
  • 统计分析
  • 数据验证
  • Data filtering and sorting
  • Statistical analysis
  • Data validation

Usage Examples

Usage Examples

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

Example 1: Read and Analyze Sales Data

用户: 分析这个 Amazon 销售报表的趋势
Claude: [使用 xlsx 技能读取文件，提取数据，生成趋势分析]
User: Analyze the trends of this Amazon sales report
Claude: [Use the xlsx skill to read the file, extract data, and generate trend analysis]

示例 2: 创建关键词矩阵

Example 2: Create a Keyword Matrix

用户: 帮我创建一个关键词研究矩阵表格
Claude: [使用 xlsx 技能创建结构化表格，添加公式计算搜索量权重]
User: Help me create a keyword research matrix spreadsheet
Claude: [Use the xlsx skill to create a structured spreadsheet and add formulas to calculate search volume weight]

示例 3: 合并多个数据源

Example 3: Merge Multiple Data Sources

用户: 把这三个 CSV 文件合并成一个 Excel 报表
Claude: [使用 xlsx 技能读取多个文件，合并数据，生成格式化报表]
User: Merge these three CSV files into an Excel report
Claude: [Use the xlsx skill to read multiple files, merge data, and generate a formatted report]

Dependencies

Dependencies

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

LiYe OS Integration

LiYe OS Integration

业务域引用

Business Domain References

此技能被以下业务域引用：
  • 02_Operation_Intelligence: Amazon 销售/关键词/PPC 报表分析
  • 07_Data_Science: 通用数据分析
  • 04_Business_Operations: 商务报表处理
This skill is referenced by the following business domains:
  • 02_Operation_Intelligence: Amazon sales/keyword/PPC report analysis
  • 07_Data_Science: General data analysis
  • 04_Business_Operations: Business report processing

三层架构位置

Three-tier Architecture Location

  • 物理层 (本文件): Skills/00_Core_Utilities/document-processing/xlsx/
  • 逻辑层索引: Skills/{domain}/index.yaml
  • L3 指令层: .claude/skills/{domain}/xlsx/
Created: 2025-12-28 | Adapted for LiYe OS
  • Physical Layer (This file): Skills/00_Core_Utilities/document-processing/xlsx/
  • Logical Layer Index: Skills/{domain}/index.yaml
  • L3 Instruction Layer: .claude/skills/{domain}/xlsx/
Created: 2025-12-28 | Adapted for LiYe OS