excel-report-generator SKILL.md skillA

excel-report-generator from wwwzhouhui/skills_collection is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add wwwzhouhui/skills_collection/excel-report-generator@git:20251112.c625f19

Pins git:20251112.c625f19 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
wwwzhouhui/skills_collection
Path
excel-report-generator/SKILL.md
Versions recorded
1
Latest version
git:20251112.c625f19, committed Nov 12, 2025
Size
8,763 bytes
Repository stars
284
License
none declared

Automatically generate Excel reports from data sources including CSV, databases, or Python data structures. Supports data analysis reports, business reports, data export, and template-based report generation using pandas and openpyxl. Activate when users mention Excel, spreadsheet, report generation, data export, or business reporting.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Excel Report Generator

自动化 Excel 报表生成工具,支持从多种数据源生成专业的 Excel 报告。

## 功能概述

这个 Skill 可以帮助你:
- 📊 从 CSV、数据库或 Python 数据结构生成 Excel 报表
- 📈 创建包含图表、格式化和公式的数据分析报告
- 📋 基于模板填充数据生成业务报告
- 💾 将系统数据批量导出为格式化的 Excel 文件
- 🎨 应用专业的样式、颜色和条件格式

## 核心技术栈

- **pandas**: 数据处理和分析
- **openpyxl**: Excel 文件读写和格式化
- **xlsxwriter**: 高级图表和格式支持(可选)

## 使用场景

### 1. 数据分析报表
从原始数据生成包含统计分析、透视表和可视化图表的综合报告。

**示例请求**:
- "帮我从这个 CSV 生成销售分析报表"
- "创建一个包含月度趋势图的数据分析 Excel"
- "生成带有统计汇总的财务报表"

### 2. 业务报告
定期生成标准化的业务报告,如销售报告、KPI 仪表板等。

**示例请求**:
- "生成本月的销售业绩报告"
- "创建 KPI 跟踪报表"
- "导出季度业务总结 Excel"

### 3. 数据导出
将数据库查询结果或系统数据导出为格式化的 Excel 文件。

**示例请求**:
- "把用户数据导出到 Excel"
- "将数据库查询结果保存为 Excel 文件"
- "导出多个工作表的数据集"

### 4. 模板填充
基于预定义的 Excel 模板填充动态数据。

**示例请求**:
- "使用这个模板生成报告"
- "填充 Excel 模板中的数据"
- "批量生成基于模板的发票"

## 使用方法

### 基本工作流程

1. **准备数据源**: CSV 文件、pandas DataFrame、数据库连接或 Python 字典
2. **定义报表需求**: 描述所需的格式、图表、样式
3. **生成报表**: 自动创建格式化的 Excel 文件
4. **验证输出**: 检查生成的文件是否符合要求

### 命令示例

**从 CSV 生成报表**:
```
请从 sales_data.csv 生成一个销售分析报表,包含:
- 按产品分类的销售汇总
- 月度销售趋势图
- Top 10 产品排名
```

**从 DataFrame 生成报表**:
```
我有一个 pandas DataFrame,帮我生成 Excel 报表,包括:
- 数据透视表
- 条件格式高亮异常值
- 自动筛选和冻结首行
```

**使用模板**:
```
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add wwwzhouhui/skills_collection/excel-report-generator@sha256:2c5de0e29bb97e1a

The line at the top of this page pins the label git:20251112.c625f19, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_zo3i3yopehtcaqfc.svg)](https://markdownregistry.com/a/art_zo3i3yopehtcaqfc)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Nov 12, 2025.

versioncommittedcommitsizeaudit
git:20251112.c625f19 latest2025-11-12 c625f19 8,763 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (8763 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

wwwzhouhui/skills_collection · 284 stars · license none declared · pushed 2026-10-16 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_zo3i3yopehtcaqfc
GET https://markdownregistry.com/api/v1/resolve?ref=wwwzhouhui/skills_collection/excel-report-generator
GET https://markdownregistry.com/api/v1/blob/2c5de0e29bb97e1af88fb17318fa4e5526821ab2c45627b462d698ad1303741b

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from wwwzhouhui/skills_collection

ai-teaching-media SKILL.md skill
wwwzhouhui/skills_collection · ai-teaching-media/SKILL.md · AI 教学媒体一体化技能包。在一个 skill 内串联 6 个子能力:通用生图执行层、技术长文智能插图、学科知识点竖版信息图、教学动图+配音教学视频、短视频 3:4…
git:20260726.4787fcc · audit A · 284 stars
ai-image-generator SKILL.md skill
wwwzhouhui/skills_collection · ai-teaching-media/ai-image-generator/SKILL.md · 通用图像生成执行层,支持 MuleRun Nano Banana 2、APImart GPT Image 2、Atlas Cloud GPT Image 2 和 Agnes Image 2.1 Flash 四种生图 API。通过…
git:20260726.4787fcc · audit A · 284 stars
article-explainer-video SKILL.md skill
wwwzhouhui/skills_collection · ai-teaching-media/article-explainer-video/SKILL.md · 把一篇技术长文/论文解读自动做成章节式解说视频(1080p, 5-8 分钟)。双主题:warm(奶油底+珊瑚红+cozy-handdrawn 透明插图,亲和感)和 midnight(深蓝黑底+琥珀金+宋体标题+executive-tech…
git:20260726.4787fcc · audit A · 284 stars
edu-subject-infographic SKILL.md skill
wwwzhouhui/skills_collection · ai-teaching-media/edu-subject-infographic/SKILL.md · 将任意学科知识点转化为竖版教育信息图(9:16)。用户只需要输入一个知识点名称(如"声现象"、"勾股定理"、"光合作用"),Skill 自动完成:识别学科/年级/章节、拆解3-5个核心子概念、分配主题色系、为每个子概念生成具体插图描述、构建…
git:20260726.4787fcc · audit A · 284 stars
edu-teaching-animation SKILL.md skill
wwwzhouhui/skills_collection · ai-teaching-media/edu-teaching-animation/SKILL.md · 把单个学科概念(中文/英文都行,如"声现象""杠杆原理""光合作用")自动做成动态教学内容。两种产出都由 HyperFrames 渲染、共用同一个 index.html(mode 变量切换):① 配音教学视频 — 分镜 + Minimax…
git:20260726.4787fcc · audit A · 284 stars
short-video-cover SKILL.md skill
wwwzhouhui/skills_collection · ai-teaching-media/short-video-cover/SKILL.md · 根据视频口播文案,为视频号/抖音/小红书短视频生成 3:4 竖版封面图。当用户需要给短视频做封面、配缩略图、出竖版题图时使用。触发词包括:做视频封面、生成视频封面图、视频号封面、抖音封面、小红书视频封面、竖版封面、3:4…
git:20260726.4787fcc · audit A · 284 stars
tech-article-diagram SKILL.md skill
wwwzhouhui/skills_collection · ai-teaching-media/tech-article-diagram/SKILL.md · 为技术长文自动识别插图位置,并生成 16:9 概念图/流程图/对比图/架构图。支持七种风格:手绘网格笔记本风(notebook)、专业扁平信息图(infographic)、现代高级科技商务风(executive-tech)、温暖手绘卡片风(…
git:20260726.4787fcc · audit A · 284 stars
dify-dsl-generator SKILL.md skill
wwwzhouhui/skills_collection · dify-dsl-generator/SKILL.md · 专业的 Dify 工作流 DSL/YML 文件生成器,根据用户业务需求自动生成完整的 Dify 工作流配置文件,支持各种节点类型和复杂工作流逻辑
v1.0.0 · audit A · 284 stars
github-readme-generator SKILL.md skill
wwwzhouhui/skills_collection · github-readme-generator/SKILL.md · Generate professional GitHub project README.md with standard structure including project intro, features, installation…
v1.0.0 · audit A · 284 stars
github-trending-wan-skill SKILL.md skill
wwwzhouhui/skills_collection · github-trending-wan-skill/SKILL.md · 抓取 GitHub Trending 当前前 5 个开源项目,先把摘要字段翻译成中文,再生成低信息密度中文简报和 Wan 2.7 海报 prompt。支持 10 种视觉风格选择。Use when user asks for GitHub…
git:20260408.54dfe3d · audit A · 284 stars
github-trending SKILL.md skill
wwwzhouhui/skills_collection · github-trending/SKILL.md · 获取 GitHub Trending 前五项目的 README 与摘要,并发送企业微信消息。适用于热门项目跟踪、技术趋势简报与团队分享。
git:20260122.2bb4461 · audit A · 284 stars
grok-imagine-image SKILL.md skill
wwwzhouhui/skills_collection · grok-imagine-image/SKILL.md · 使用 grok-imagine-image 模型,通过兼容 Grok2API / OpenAI 风格的接口(`/v1/images/generations`)生成图片。当用户要求用 Grok Imagine /…
git:20260726.4787fcc · audit B · 284 stars

Every file in wwwzhouhui/skills_collection

Browse by kind, by grade A, or by owner.