Office Xlsx Expert

Office Xlsx Expert is an Automation skill for Claude Code, published by val1813 in kwcode.

688 stars92 forkson val1813/kwcodeAdded 2026/08/12Repository updated 2026/05/14

Install in seconds

Install Office Xlsx Expert

Copy Office Xlsx Expert into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.

terminal

npx degit https://github.com/val1813/kwcode/tree/master/kaiwu/builtin_experts/office_xlsx ~/.claude/skills/office_xlsx

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/val1813/kwcode.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file: kaiwu/builtin_experts/office_xlsx/SKILL.md in val1813/kwcode
Installs to: ~/.claude/skills/office_xlsx
Collection: One of 19 skills cataloged from this repository
Category: Automation — 1523 skills

What Office Xlsx Expert does

Office Xlsx Expert creates and formats Excel workbooks with openpyxl. Use it for styled headers, zebra striping, freeze panes, data validation, conditional formatting, formulas, and column sizing.

Office Xlsx Expert is cataloged under Automation on DirSkills.

Documentation

README

From the original repository

领域知识

使用openpyxl库，Workbook()创建，ws = wb.active获取活动sheet
表头样式：深色背景（#003366）+白色加粗字体+居中对齐
斑马纹：奇偶行交替浅灰（#F2F2F2）和白色背景
冻结首行：ws.freeze_panes = 'A2'，冻结首行+首列用'B2'
列宽自适应：遍历列取max(len(str(cell.value)))设置column_dimensions
数据验证：DataValidation(type="list", formula1='"选项1,选项2"')
条件格式：ColorScaleRule/CellIsRule高亮异常值
公式：直接写Excel公式字符串如'=SUM(B2:B100)'，不用Python计算
数字格式：金额'#,##0.00'，百分比'0.00%'，日期'YYYY-MM-DD'
合并单元格：ws.merge_cells('A1:D1') 用于标题行
边框：thin边框包围数据区域，表头用medium底边框

经验规则（自动生成）

Frequently asked about Office Xlsx Expert

What else does val1813 publish alongside Office Xlsx Expert?
Office Xlsx Expert is one of 19 skills that DirSkills catalogs from val1813/kwcode, the repository it ships in. Its siblings there include API Expert, Bug Fix Expert and DeepSeek API Expert. Each one is a separate skill with its own page in this directory, installs the same way Office Xlsx Expert does, and is maintained by val1813 in that same repository. The rest of the collection is listed on the val1813/kwcode page.
How does Office Xlsx Expert compare to other Automation skills?
Office Xlsx Expert ranks #1069 by stars among the 1523 Automation skills in this catalog. The most-starred ones next to it are Autonomous Loops, Autonomous Agent Harness and Automation Audit Ops. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of Office Xlsx Expert against them. Open each page to compare what they document and how they install.