跳到正文
TakoAPI
返回技能列表

attendance-sheet

由 gykdly 提供

PDF & Documents
807下载量由 clawskills.sh 提供
0浏览量
0 个赞登录后即可为这个技能点赞
—暂无评分
你的评分

简介

Generate professional attendance sheets in xlsx format from employee work information.

描述

该技能的功能

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.

何时使用

  • 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

示例工作流

输入

User asks: Generate December attendance sheet for employees Zhang San, Li Si, Wang Wu with normal, late, and leave statuses

智能体
  1. 1

    Parses employee names and date range from the request

  2. 2

    Maps attendance status codes to the supported types (normal, late, absent, leave, overtime)

  3. 3

    Runs generate_attendance.py with the structured input data

  4. 4

    Applies color coding per status and calculates summary statistics

  5. 5

    Writes the output to 2024年12月考勤统计表.xlsx

输出

A formatted .xlsx file with employee rows, date columns, color-coded status cells, and totals for late count and attendance days

安装

clawhub install gykdly/attendance-sheet

运行 CLI 命令,或把这段提示词粘贴到 Claude Code、Cursor、Codex 或你在用的任意编程智能体里。

链接