Overview
- Skill Key
- gykdly/attendance-sheet
- Author
- gykdly
- Source Repo
- openclaw/skills
- Version
- 1.0.0
- Source Path
- skills/gykdly/attendance-sheet
- Latest Commit SHA
- 518d33dea0d9c8cad758f513e81367dc955ad90f
Generate professional attendance sheets in xlsx format from employee work information. Perfect for HR, team management, and daily attendance tracking.
Stars
0
Installs
0
Status
ACTIVE
Visibility
PUBLIC
直接复制以下提示词,发送给你的 AI 助手即可完成安装。
请先检查是否已安装 SkillHub 商店,若未安装,请根据 https://skillhub-1388575217.cos.ap-guangzhou.myqcloud.com/install/skillhub.md 安装 SkillHub 商店,然后安装 attendance-sheet 技能。 若已安装,则直接安装 attendance-sheet 技能。
# 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:
```json
{
"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
edholofy
University for AI agents. 92 courses, 4400+ scenarios, any model via OpenRouter. Auto-training loops generate per-model SKILL.md documents. Works with Claude Code, OpenClaw, Cursor, Windsurf. No fine-tuning required.
lethehades
macOS WPS Office workflow helper skill for safer document preparation, conversion, export, and compatibility guidance
capt-marbles
Web scraping and crawling with Firecrawl API. Fetch webpage content as markdown, take screenshots, extract structured data, search the web, and crawl documentation sites. Use when the user needs to scrape a URL, get current web info, capture a screenshot, extract specific data from pages, or crawl docs for a framework/library.
caqlayan
Tweet Processor Skill
carev01
Full-text search across structured Markdown documentation archives using SQLite FTS5. Use when you need to search large collections of Markdown articles that are separated by "---" delimiters and contain source URLs (marked with "*Source:" pattern). Provides fast BM25-ranked search with automatic source URL extraction for citations. Ideal for research, documentation lookups, and knowledge base exploration. Requires indexing documentation first with `docs.py index`.
camelsprout
DuckDB CLI specialist for SQL analysis, data processing and file conversion. Use for SQL queries, CSV/Parquet/JSON analysis, database queries, or data conversion. Triggers on "duckdb", "sql", "query", "data analysis", "parquet", "convert data".