好的！你提供的图片是一个“工作计划及日志记录表”，结构清晰，包含日期、倒计时、分类（计划事项/日志记录）、工作项目纪录、备注等模块。我们可以用 Python 的 `openpyxl` 库来创建这个 Excel 表格。 --- ✅ **目标功能：** - 创建标题行：“工作计划及日志记录表” - 设置日期区域（2026年3月5日 星期四） - 设置倒计时区域（到2026年12月31日还有301天） - 设置“农历”、“周度条”、“天气”等字段（部分可留空或模拟） - 设置“计划事项”和“日志记录”两个大区块，每个区块有多行空白行用于填写 - 设置“备注”列 - 应用基础样式（边框、背景色、字体对齐等） --- **依赖库安装：** ```bash pip install openpyxl ``` --- ✅ **完整 Python 代码如下：** ```python from openpyxl import Workbook from openpyxl.styles import Font, Alignment, Border, Side, PatternFill, Color from openpyxl.utils import get_column_letter from datetime import date, timedelta # 创建工作簿和工作表 wb = Workbook() ws = wb.active ws.title = "工作计划及日志" # 定义常用样式 thin_border = Border( left=Side(style='thin'), right=Side(style='thin'), top=Side(style='thin'), bottom=Side(style='thin') ) header_fill = PatternFill(start_color="D9EAD3", end_color="D9EAD3", fill_type="solid") # 浅绿 date_fill = PatternFill(start_color="FFEB9C", end_color="FFEB9C", fill_type="solid") # 浅黄 blue_fill = PatternFill(start_color="4FC3F7", end_color="4FC3F7", fill_type="solid") # 蓝色 light_blue_fill = PatternFill(start_color="B3E5FC", end_color="B3E5FC", fill_type="solid") # 浅蓝 yellow_fill = PatternFill(start_color="FFF9C4", end_color="FFF9C4", fill_type="solid") # 淡黄 center_align = Alignment(horizontal='center', vertical='center') left_align = Alignment(horizontal='left', vertical='center') # === 第1行：主标题 === ws.merge_cells('A1:N1') ws['A1'] = "工作计划及日志记录表" ws['A1'].font = Font(size=18, bold=True) ws['A1'].alignment = center_align ws.row_dimensions[1].height = 30 # === 第2行：日期信息 === # A2: 日期 ws['A2'] = "日期" ws['A2'].fill = date_fill ws['A2'].alignment = center_align ws['A2'].border = thin_border # B2~G2: 年月日拆分 for col in range(2, 8): cell = ws.cell(row=2, column=col) cell.fill = header_fill cell.border = thin_border cell.alignment = center_align ws['B2'] = "2026" ws['C2'] = "年" ws['D2'] = "3" ws['E2'] = "月" ws['F2'] = "5" ws['G2'] = "日" # H2: 星期标签 ws['H2'] = "星期" ws['H2'].fill = blue_fill ws['H2'].alignment = center_align ws['H2'].border = thin_border # I2: 星期值 ws['I2'] = "四" ws['I2'].fill = blue_fill ws['I2'].alignment = center_align ws['I2'].border = thin_border # J2: 农历标签 ws['J2'] = "农历" ws['J2'].fill = yellow_fill ws['J2'].alignment = center_align ws['J2'].border = thin_border # K2~M2: 农历内容（这里显示 #NAME? 是因为公式错误，我们暂时填个占位符） ws.merge_cells('K2:M2') ws['K2'] = "#NAME?" # 实际应用中可用农历库计算，此处简化 ws['K2'].fill = yellow_fill ws['K2'].alignment = center_align ws['K2'].border = thin_border # N2: 天气标签 ws['N2'] = "天气:" ws['N2'].fill = header_fill ws['N2'].alignment = center_align ws['N2'].border = thin_border # === 第3行：倒计时信息 === # A3: 倒计时距 ws['A3'] = "倒计时:\n距" ws['A3'].fill = light_blue_fill ws['A3'].alignment = center_align ws['A3'].border = thin_border # B3~G3: 目标日期拆分 for col in range(2, 8): cell = ws.cell(row=3, column=col) cell.fill = header_fill cell.border = thin_border cell.alignment = center_align ws['B3'] = "2026" ws['C3'] = "年" ws['D3'] = "12" ws['E3'] = "月" ws['F3'] = "31" ws['G3'] = "日" # H3: “还有” ws['H3'] = "还有" ws['H3'].fill = light_blue_fill ws['H3'].alignment = center_align ws['H3'].border = thin_border # I3: 天数 ws['I3'] = "三百〇一" ws['I3'].fill = light_blue_fill ws['I3'].alignment = center_align ws['I3'].border = thin_border # J3: “天” ws['J3'] = "天" ws['J3'].fill = light_blue_fill ws['J3'].alignment = center_align ws['J3'].border = thin_border # K3: 周度条标签 ws['K3'] = "周度条" ws['K3'].fill = yellow_fill ws['K3'].alignment = center_align ws['K3'].border = thin_border # L3~M3: 周度条内容（用 I 字符模拟进度条） ws.merge_cells('L3:M3') ws['L3'] = "IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII" ws['L3'].fill = yellow_fill ws['L3'].alignment = center_align ws['L3'].border = thin_border # N3: 天气值（留空） ws['N3'] = "" ws['N3'].fill = header_fill ws['N3'].border = thin_border # === 第4行：分类标题 === ws['A4'] = "分类" ws['A4'].fill = header_fill ws['A4'].alignment = center_align ws['A4'].border = thin_border ws.merge_cells('B4:M4') ws['B4'] = "工作项目纪录" ws['B4'].alignment = center_align ws['B4'].border = thin_border ws['N4'] = "备注" ws['N4'].fill = header_fill ws['N4'].alignment = center_align ws['N4'].border = thin_border # === 第5~9行：计划事项区块 === ws.merge_cells('A5:A9') ws['A5'] = "计划\n事项" ws['A5'].alignment = center_align ws['A5'].border = thin_border for row in range(5, 10): for col in range(2, 14): # B to N cell = ws.cell(row=row, column=col) cell.border = thin_border if col == 14: # 备注列 cell.fill = header_fill else: cell.fill = PatternFill(start_color="FFFFFF", end_color="FFFFFF", fill_type="solid") # === 第10~24行：日志记录区块 === ws.merge_cells('A10:A24') ws['A10'] = "日志\n记录" ws['A10'].alignment = center_align ws['A10'].border = thin_border for row in range(10, 25): for col in range(2, 14): cell = ws.cell(row=row, column=col) cell.border = thin_border if col == 14: cell.fill = header_fill else: cell.fill = PatternFill(start_color="FFFFFF", end_color="FFFFFF", fill_type="solid") # 调整列宽 for col in ws.columns: max_length = 0 column = col[0].column_letter for cell in col: try: if len(str(cell.value)) > max_length: max_length = len(str(cell.value)) except: pass adjusted_width = (max_length + 2) * 1.2 ws.column_dimensions[column].width = min(adjusted_width, 25) # 最大不超过25 # 保存文件 wb.save("工作计划及日志记录表.xlsx") print("✅ Excel 文件已生成：工作计划及日志记录表.xlsx") ``` --- ✅ **效果说明：** - 表格结构与截图高度一致。 - 使用了颜色区分不同区域（如日期区、计划区、日志区）。 - “周度条”用 `I` 字符模拟进度条。 - “农历”字段保留 `#NAME?` 作为占位符（实际项目中可接入农历API或库如 `lunarcalendar`）。 - 所有单元格都有边框，便于打印或查看。 - 自动调整列宽，避免文字被截断。 --- 💡 **扩展建议：** - 如果想动态计算“还剩多少天”，可以替换硬编码的“三百〇一”为： ```python target_date = date(2026, 12, 31) today = date(2026, 3, 5) days_left = (target_date - today).days ws['I3'] = f"{days_left}天" ``` - 农历部分可使用 [`lunarcalendar`](https://pypi.org/project/lunarcalendar/) 库自动转换。 - 可添加条件格式、数据验证、下拉菜单等功能增强交互性。 --- ✅ 运行后会在当前目录生成一个名为 `工作计划及日志记录表.xlsx` 的文件，打开即可看到与截图几乎一致的表格！ 需要我帮你加上“自动更新日期”或“农历转换”功能吗？欢迎继续提问