界面已本地化;技能介绍与说明文档按所选语言由 AI 自动翻译,代码、命令、路径和专业术语保留原文,以原作者文档为准。
探索技能
文档与办公 · SKILL.md

skill-012

skill-012

【文档与办公】A tool designed to create, manage, and apply templates across Excel files for consistent formatting and efficiency in document creation.

独立 GitHub 快照 · 自动分类 · 以原作者文档为准

技能说明

GitHub

name: skill-012 description: "A tool designed to create, manage, and apply templates across Excel files for consistent formatting and efficiency in document creation." license: Proprietary. LICENSE.txt has complete terms

Requirements for Outputs

Template Management Standards

Template Creation

  • Users must be able to create templates that define standard layouts, styles, and elements used across various documents.
  • Example code snippet:
from openpyxl import Workbook

def create_template():
    wb = Workbook()
    ws = wb.active
    ws.title = "Template"
    ws['A1'] = "Header"
    ws['B1'] = "Data"
    return wb

Template Application

  • Templates should be easily applied to new documents to maintain consistency in presentation.
  • Example code snippet:
def apply_template(file_path, template):
    wb = load_workbook(file_path)
    # Apply styles from template
    return wb

Documentation and Version Control

Change Documentation

  • Track changes made to templates over time, including a version history to facilitate updates.
  • Example: "Version 1.1: Adjusted header styles on 2023-03-01."

User Guidance

  • Provide comprehensive documentation outlining how to use and modify templates effectively.
  • Include examples for common scenarios and best practices in template application.
我的收藏