Attendance Sheet

Generate professional attendance sheets in xlsx format from employee work information. Perfect for HR, team management, and daily attendance tracking.

Security Scan

The skill's code and instructions match its stated purpose (generating Excel attendance sheets); it doesn't request credentials, perform network access, or use surprising system capabilities.

Purpose & Capability

The name/description (generate xlsx attendance sheets) aligns with the provided SKILL.md and the included Python script which builds an .xlsx using openpyxl. There are no unrelated credentials, binaries, or config paths requested.

Instruction Scope

SKILL.md asks for employee/date/attendance input and the script consumes command-line args or a JSON payload and writes a single .xlsx file. The instructions do not direct the agent to read unrelated files, environment variables, or transmit data externally.

Install Mechanism

There is no install spec (lowest-risk), but the script depends on the openpyxl Python package which is not declared in metadata—users will need Python and openpyxl available. No downloads or external installers are invoked by the skill itself.

Credentials

The skill declares no environment variables or credentials and the code does not access os.environ or other secrets. Requested environment access is proportionate (none).

Persistence & Privilege

The skill is not marked always:true and does not modify other skills or system-wide settings. It only writes the output .xlsx file supplied by the user.

Assessment

This skill appears coherent and low-risk: it simply generates XLSX attendance sheets. Before running, ensure you have Python and the openpyxl package installed (e.g., pip install openpyxl) and run the script in a sandbox or virtualenv if the source is unfamiliar. Review the script if you need behavior not present (for example, the code sets up color mappings but does not populate status cells automatically — you must fill cells or extend the script). Also be mindful of the output filename to avoid unintentionally overwriting important files. If you require dependency declarations or assurance about provenance, request a source/homepage or a requirements.txt from the publisher.

Attendance Sheet Generator

Overview

Generate professional attendance sheets (考勤表) in xlsx format based on employee work information. Input employee names, dates, and attendance status (normal, late, absent, leave, etc.) to automatically create formatted Excel files ready for HR or management use.

When to Use

Use this skill when:

• Creating monthly attendance reports
• Generating employee attendance sheets
• Converting raw attendance data to formatted Excel
• HR needs standardized attendance documentation

Input Format

Provide the following information:

员工: 张三, 李四, 王五
日期范围: 2024-01-01 至 2024-01-31
考勤类型: 正常出勤, 迟到, 早退, 缺勤, 请假, 加班

Or structured format:

{
  "employees": ["张三", "李四", "王五"],
  "start_date": "2024-01-01",
  "end_date": "2024-01-31",
  "attendance_types": ["正常出勤", "迟到", "早退", "缺勤", "请假", "加班"]
}

Output

Generates an xlsx file with:

• Employee names in rows
• Dates in columns
• Attendance status cells with color coding
• Summary statistics (total days, late count, etc.)
• Professional formatting

Usage Examples

Example 1 - Monthly Report:

Input: 员工列表 + 1月考勤数据
Output: 2024年1月考勤表.xlsx

Example 2 - Simple Attendance:

Input: 今天出勤人员: 张三, 李四
Output: 出勤记录_20240101.xlsx

Example 3 - Full Month with Multiple Types:

Input: 全体员工12月考勤数据（含迟到、请假）
Output: 2024年12月考勤统计表.xlsx

Resources

scripts/

• generate_attendance.py - Main Python script for generating attendance sheets