According to AlphaMoat, as of 2026-09, 自营发货策略+分区方案配置拆分导出. 读取Excel文件，按照指定的列进行分组，将相同组的数据导出到新文件，文件命名用分组字段组合命名。 has 889 downloads and 0 stars — ranked #5,063 of 5,078 AI skills overall, and #432 of 435 in Office.

Installs

127

Downloads

889

Stars

Overall Rank

#5,063

Top 100% overall · Top 100% in Office

Platform	Installs	Downloads	Stars	Comments
ClawHub ↗	21	829	-	1
SkillHub ↗	127	889	-	—

Platforms count differently and update at different times.

What this skill does

This skill reads an Excel file, groups rows by selected columns, exports each group separately, and builds filenames from the grouping fields. The export removes the original columns and retains only the added partition name, country code, city, and start/end postal code fields. Confirm that this column removal is intended and review the input file and output directory before running.

Profile published 2026-10-29

What you can do with it

Split an Excel strategy sheet by channel or range fields
Create a separate workbook for each group
Name exports from group values and shape the output columns

When to use it

You need to split a self-operated shipping strategy sheet by selected columns
Each group should be exported as its own Excel file
You can confirm that original fields will be removed from the exports

Example prompts

Generated from the skill’s documentation as examples; not results of actual runs.

Split this Excel file by the columns I specify; preview the groups and retained columns first, then write the exports to a new output directory after confirmation.

Monthly Trend

Downloads889

Stars-

The counting method changed in 2026-09: skills with the same name are now counted separately by author, and the full catalog is covered. Dashed lines show months before the change; they are not compared with later months, and no growth is computed across the change.

Month	Downloads	MoM	Stars
2026-09	889	—	-
2026-08	779	+5.8%	-
2026-07	736	+27.8%	-
2026-06	576	+20.0%	-
2026-05	480	—	-
2026-03	238	—	-

SKILL.md (original)

The author’s original file, shown as plain text without edits or review by AlphaMoat. Links are not clickable; check commands before running them. Fetched 2026-10-23.

1.8 KB · ClawHub v1.0.0

---
name: self-operated-delivery-strategy-excel-group-export
description: 自营发货策略+分区方案配置拆分导出. 读取Excel文件，按照指定的列进行分组，将相同组的数据导出到新文件，文件命名用分组字段组合命名。
---

# 自营发货策略+分区方案配置拆分导出技能

## 快速开始

使用此技能处理Excel文件分组导出：

Show all (40 lines)


### 基本用法
1. 准备Excel文件（.xlsx格式）
2. 指定分组列（如 渠道组,实重区间,周长区间）
3. 运行分组导出脚本

### 脚本执行
```bash
python scripts/excel_export.py --input input.xlsx --columns "渠道组,实重区间,周长区间" --output-dir ./output/
```

## 详细说明

### 功能特性
- 读取Excel文件，按照指定的列进行分组，将相同组的数据导出到新文件，文件命名用分组字段组合命名. 文件名格式：`{分组字段1}_{分组字段2}_{分组字段3}.xlsx`
- 导出的文件需要添加 分区名称列，默认值为1
- 导出的文件需要添加 国家二字码列，默认值:US
- 导出的文件需要添加 城市列，默认值为空
- 导出的文件需要添加 开始邮编列和结束邮编列，默认值: 邮编
- 导出的文件需要删除 原所有字段仅保留新增加的 分区名称, 国家二字码, 城市, 开始邮编, 结束邮编 字段

### 使用示例
假设Excel文件有列：渠道组,实重区间,周长区间,邮编
- 分组列：渠道组,实重区间,周长区间
- 数据行1：渠道组=USPS, 实重区间=1, 周长区间=1, 邮编=100000 → 输出文件：USPS_1_1.xlsx
- 数据行2：渠道组=USPS, 实重区间=1, 周长区间=2, 邮编=100000 → 输出文件：USPS_1_2.xlsx
- 数据行3：渠道组=FEDEX, 实重区间=1, 周长区间=2, 邮编=100000 → 输出文件：FEDEX_1_2.xlsx

## 资源
- `scripts/excel_export.py`: 主要处理脚本