excel-xlsx

name	excel-xlsx
slug	excel-xlsx
version	1.0.1
homepage	https://clawic.com/skills/excel-xlsx
description	Excel文件处理技能。读取、写入、生成Excel文件，支持类型、日期、公式、跨平台。当用户说"处理Excel"、"读Excel"、"生成表格"、"xlsx"时使用。
changelog	Added Core Rules and modern skill structure
triggers	["Excel","xlsx","电子表格"]

Setup

On first use, read setup.md for integration guidelines. Ask user preferences naturally during conversation.

When to Use

User needs to read, write, or generate Excel files (.xlsx, .xls, .xlsm) for tabular/structured data. Agent handles type coercion, date serialization, formula evaluation, and cross-platform quirks.

✅ 使用 Excel

• 客户清单、报价明细、对比表
• 数字计算、筛选、排序、数据透视
• Pipeline 数据、数据库导出
• 行列结构的结构化数据

❌ 不使用 Excel

• 叙事文本、段落、标题为主的报告 → 用 word-docx 生成 .docx
• 背调报告、市场分析、ICP 分析 → 用 word-docx
• 开发信、商务函件 → 用 word-docx 或对话中展示
• 简短文本（不足 1 页）→ 直接在对话中展示

Architecture

Memory lives in ~/excel-xlsx/. See memory-template.md for structure.

~/excel-xlsx/
└── memory.md     # Preferences, tools, pain points

Quick Reference

Topic	File
Setup	setup.md
Memory template	memory-template.md

Core Rules

1. Dates Are Serial Numbers

Excel stores dates as days since 1900-01-01 (Windows) or 1904-01-01 (Mac legacy). Check workbook date system before converting. Time is fractional: 0.5 = noon, 0.25 = 6 AM.

2. The 1900 Leap Year Bug

Excel incorrectly treats 1900 as a leap year. Serial 60 represents Feb 29, 1900 (invalid date). Account for this when calculating dates before March 1, 1900.

3. 15-Digit Precision Limit

Numbers beyond 15 digits silently truncate. Use TEXT format for: phone numbers, IDs, credit cards, any long numeric identifiers. Leading zeros also require TEXT.

4. Formulas vs Cached Values

Cells may contain both formula and cached result. Some readers return formula string, others return cached value. Force recalculation if cached values might be stale.

5. Merged Cells Are Traps

Only the top-left cell of a merged range holds the value. Reading other cells in the merge returns empty. Hidden rows/columns still contain data.

6. Cross-Platform Testing Required

Windows vs Mac Excel can differ in date system. LibreOffice/Google Sheets may not support all features. Always test roundtrip compatibility when generating files for unknown consumers.

7. Use Streaming for Large Files

Loading large files fully into RAM causes memory issues. Use streaming readers (row-by-row) for files with 100K+ rows. Empty rows at end may be padded by some writers.

Common Traps

• Type inference on read → Numbers stored as text stay text; explicit conversion needed
• Column index confusion → A=0 or A=1 varies by library; always verify convention
• Newlines in cells → \n works but cell needs "wrap text" format to display
• External references → [Book.xlsx]Sheet!A1 breaks when source file moves
• Password protection → Trivial to break; not real security; encrypt file externally if needed
• XLSM files → Contain macros (security risk); XLSB is binary (faster but less compatible)
• Shared strings → Large files reuse text indices; libraries handle this, but be aware

Format Limits

Format	Rows	Columns	Notes
XLSX	1,048,576	16,384 (XFD)	Modern default
XLS	65,536	256	Legacy, avoid
CSV	Unlimited	Unlimited	No formatting

Security & Privacy

Data that stays local:

• All file processing happens locally
• User preferences stored in ~/excel-xlsx/memory.md with consent
• No external services called

This skill does NOT:

• Send data to external endpoints
• Require network access

Related Skills

Install with clawhub install <slug> if user confirms:

• csv — CSV parsing and generation
• data — Data processing patterns
• data-analysis — Analysis workflows

Feedback

• If useful: clawhub star excel-xlsx
• Stay updated: clawhub sync