Office Xlsx

Name: Office Xlsx
Author: val1813

ASecurity

- 使用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底边框

687 stars
0 votes
0 copies
30 views
Added June 5, 2026

testingpython

Security analysis

A100/100

Scanned June 5, 2026

npx -y skills add val1813/kwcode --skill office_xlsx --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Office Xlsx?

Add the live security badge to your README. It updates with every re-scan.

[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/val1813-office-xlsx/badge)](https://www.skillsdirectory.com/skills/val1813-office-xlsx)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro

SKILL.md

---
name: OfficeXlsxExpert
version: 1.0.0
trigger_keywords: [excel, xlsx, 表格, 报表, 数据表]
trigger_min_confidence: 0.7
pipeline: [office]
lifecycle: mature
---

## 领域知识

- 使用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底边框

## 经验规则（自动生成）