craft-report-excel

Create and edit fixed-format craft department Excel reports from templates.

Updated Mar 25, 2026
One-click install
npx skills add https://github.com/JojaCola312/skills --skill craft-report-excel
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: craft-report-excel
Source: https://github.com/JojaCola312/skills/tree/main/craft-report-excel
Command: npx skills add https://github.com/JojaCola312/skills --skill craft-report-excel

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates the creation and editing of工艺部日报、周报和工艺总结 Excel表格 using a fixed template, ensuring the layout, merged cells, row height, column width, and formatting remain intact.

Core Features & Use Cases

  • Fixed template-driven data entry for daily and weekly reports across designated units (光刻, 刻蚀, 薄膜, 掺杂, 晶背, 检测, 生产, 整合).
  • Supports both editing existing workbooks or generating new ones from templates; preserves original formatting and structure while updating only target cells.
  • Provides a structured payload-driven workflow with scripts, references, and assets to supply data, guidelines, and templates.

Quick Start

起始时请先选择编辑现有表格还是按模板新建表格,然后按照固定的日期排布填写各工艺单元的日报/周报内容。

Frequently Asked Questions about craft-report-excel

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Excel report generation while preserving template formatting?

You can automate Excel report generation by using a payload-driven workflow that updates only targeted cells in a fixed template, ensuring merged cells, row height, column width, and overall layout remain fully intact.

Can I edit an existing workbook without breaking the original template layout?

Yes, you can edit an existing workbook by validating inputs and updating only specific target cells, which strictly preserves the original template layout, formatting, and structure without unintended modifications.

How does fixed-format manufacturing reporting work across multiple process units?

Fixed-format manufacturing reporting works by applying a structured, template-driven workflow to fill daily and weekly reports across units like lithography, etching, and integration with strict date sequencing.

Does openpyxl support preserving merged cells and formatting when updating Excel templates?

Yes, openpyxl supports preserving merged cells, row heights, column widths, and formatting when updating Excel templates, allowing automated scripts to modify only designated target cells while keeping the original layout intact.

What is the best way to generate daily and weekly manufacturing reports from a fixed template?

The best way to generate daily and weekly manufacturing reports is using a structured workflow that validates inputs and applies strict date sequencing across process units while updating only targeted cells in the template.

What are the limitations of automating Excel template reports for manufacturing units?

The main limitation is that the automation relies on a strictly fixed template format and specific date sequencing, meaning any deviation in the template structure or process unit naming may require manual adjustment.