Python生成日历导出Excel

import openpyxl
from openpyxl.styles import Font, Alignment, Border, Side, PatternFill, NamedStyle
from openpyxl.utils import get_column_letter
from datetime import datetime, date, timedelta
from calendar import monthcalendar, month_abbr
import holidays
import os

# 创建中国节假日对象
cn_holidays = holidays.CN(years=2025)

# 创建工作簿
wb = openpyxl.Workbook()
wb.remove(wb.active)  # 删除默认sheet

# 定义样式
header_style = NamedStyle(name="header_style")
header_style.font = Font(bold=True, color="FFFFFF", size=12)
header_style.fill = PatternFill(start_color="4472C4", fill_type="solid")
header_style.alignment = Alignment(horizontal="center", vertical="center")
header_style.border = Border(left=Side(style='thin'), right=Side(style='thin'), top=Side(style='thin'),
                             bottom=Side(style='thin'))

weekend_style = NamedStyle(name="weekend_style")
weekend_style.font = Font(color="FF0000", bold=True)
weekend_style.fill = PatternFill(start_color="FFF2CC", fill_type="solid")
weekend_style.border = Border(left=Side(style='thin'), right=Side(style='thin'), top=Side(style='thin'),
                              bottom=Side(style='thin'))

holiday_style = NamedStyle(name="holiday_style")
holiday_style.font = Font(color="0000FF", bold=True)
holiday_style.fill = PatternFill(start_color="F2F2F2", fill_type="solid")
holiday_style.border = Border(left=Side(style='thin'), right=Side(style='thin'), top=Side(style='thin'),
                              bottom=Side(style='thin'))

normal_day_style = NamedStyle(name="normal_day_style")
normal_day_style.alignment = Alignment(horizontal="center", vertical="center")
normal_day_style.border = Border(left=Side(style='thin'), right=Side(style='thin'), top=Side(style='thin'),
                                 bottom=Side(style='thin'))

# 添加样式到工作簿
wb.add_named_style(header_style)
wb.add_named_style(weekend_style)
wb.add_named_style(holiday_style)
wb.add_named_style(normal_day_style)

# 为每个月创建日历
for month in range(1, 13):
    month_title = f"{month_abbr[month]}"
    ws = wb.create_sheet(title=month_title)

    # 设置月份标题
    ws.merge_cells('A1:G1')
    ws['A1'] = f"{month_title}"
    ws['A1'].style = header_style

    # 设置星期标题
    weekdays = ["一", "二", "三", "四", "五", "六", "日"]
    for col, day in enumerate(weekdays, start=1):
        cell = ws.cell(row=3, column=col, value=day)
        cell.style = header_style
        ws.column_dimensions[get_column_letter(col)].width = 12

    # 获取当月日历
    cal = monthcalendar(2025, month)

    # 填充日期
    for week_num, week in enumerate(cal, start=4):
        for day_num, day in enumerate(week, start=1):
            if day != 0:
                current_date = date(2025, month, day)
                cell = ws.cell(row=week_num, column=day_num, value=day)

                # 判断是否是周末
                if day_num in [6, 7]:  # 星期六、星期日
                    cell.style = weekend_style
                else:
                    cell.style = normal_day_style

                # 判断是否是节假日
                if current_date in cn_holidays:
                    cell.style = holiday_style
                    holiday_name = cn_holidays.get(current_date)
                    ws.cell(row=week_num, column=day_num, value=f"{day}\n{holiday_name}").alignment = Alignment(
                        horizontal="center", vertical="center", wrap_text=True)

    # 添加备注说明
    ws['A10'] = "图例说明:"
    ws['B10'] = "红色: 周末"
    ws['B10'].style = weekend_style
    ws['D10'] = "蓝色: 法定节假日"
    ws['D10'].style = holiday_style

# 创建目标目录(如果不存在)
path = "../../output/cale"
os.makedirs(path, exist_ok=True)

# 保存文件到指定路径
filename = "2025年日历.xlsx"
wb.save(path + "/" + filename)
print(f"2025年日历已生成,文件名: {filename}")

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值