TopRank Skills

Home / Claw Skills / 文档 / attendance-sheet
Official OpenClaw rules 36%

attendance-sheet

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 技能。

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

Extracted Content

SKILL.md excerpt

# 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

Related Claw Skills

edholofy

dojo.md

★ 4

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

wps-macos-helper

★ 1

macOS WPS Office workflow helper skill for safer document preparation, conversion, export, and compatibility guidance

capt-marbles

firecrawl

★ 0

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

★ 0

Tweet Processor Skill

carev01

md-docs-search

★ 0

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-en

★ 0

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".