Setup & Installation
openclaw skills install @gykdly/attendance-sheet
Or with the ClawHub CLI, for registry-managed skill folders outside a full OpenClaw workspace:
npx clawhub install attendance-sheet
What This Skill Does
Generates formatted Excel attendance sheets from employee work data. Accepts employee names, date ranges, and attendance status codes, then outputs a color-coded .xlsx file with summary statistics.
Skips manual Excel formatting by producing a ready-to-share .xlsx file with color coding and totals in one step.
When to use it
- Creating a monthly HR attendance report for 50 employees
- Converting raw daily check-in logs into a formatted spreadsheet
- Tracking late arrivals and absences across a team for a pay period
- Preparing attendance documentation for a performance review
- Generating a one-day attendance record for a small team
Example Workflow
Here's how your AI assistant might use this skill in practice.
INPUT
User asks: Generate December attendance sheet for employees Zhang San, Li Si, Wang Wu with normal, late, and leave statuses
AGENT
- 1Parses employee names and date range from the request
- 2Maps attendance status codes to the supported types (normal, late, absent, leave, overtime)
- 3Runs generate_attendance.py with the structured input data
- 4Applies color coding per status and calculates summary statistics
- 5Writes the output to 2024年12月考勤统计表.xlsx
OUTPUT
A formatted .xlsx file with employee rows, date columns, color-coded status cells, and totals for late count and attendance days