xlsx

Source: ComposioHQ/awesome-claude-skills Adapted for: LiYe OS Three-tier Architecture

When to Use This Skill

• 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

1. File Reading and Writing

• Supports .xlsx, .xlsm, .csv, .tsv formats
• Preserves original formulas and formatting
• Handles multi-sheet workbooks

2. Formulas and Calculations

• Create and edit formulas
• Supports common functions (SUM, AVERAGE, VLOOKUP, IF, etc.)
• Formula recalculation

3. Data Visualization

• Create charts (bar charts, line charts, pie charts, etc.)
• Conditional formatting
• Pivot tables

4. Formatting

• Cell styles (font, color, borders)
• Number formats (currency, percentage, date)
• Adjust column width and row height

5. Data Analysis

• Data filtering and sorting
• Statistical analysis
• Data validation

Usage Examples

Example 1: Read and Analyze Sales Data

User: Analyze the trends of this Amazon sales report
Claude: [Use the xlsx skill to read the file, extract data, and generate trend analysis]

Example 2: Create a Keyword Matrix

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]

Example 3: Merge Multiple Data Sources

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

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

LiYe OS Integration

Business Domain References

• 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

• 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/