Q3e14159: import pandas as pd import numpy as np from openpyxl import Workbook from import Font, Border, Side from import Image # 创建数据 student = ['王一', '钱二', '周三', '吴四', '李五', '钱六', '郑七', '吴八', '李九'] (0) scores = (0, 101, size=(len(student), 3)) df = (scores, columns=['语文', '数学', '英语'], index=student) df['总分'] = (axis=1) # 创建Excel工作簿和工作表 excel = '学生成绩统计表.xlsx' wb = Workbook() ws = = '成绩表' # 设置标题行 titles = [' ', '语文', '数学', '英语', '总分'] for col_num, title in enumerate(titles, start=1): (row=1, column=col_num, value=title) # 填充学生数据 for row_num, (student_name, scores) in enumerate(zip(student, ), start=2): (row=row_num, column=1, value=student_name) # 写入学生姓名 for col_num, score in enumerate(scores, start=2): # 从第二列开始填充分数 (row=row_num, column=col_num, value=score) # 写入总分 (row=row_num, column=5, value=[student_name, '总分']) # 设置边框 for row in ws.iter_rows(min_row=1, max_row=len(student)+1, min_col=1, max_col=5): for cell in row: = Border( left=Side(color="000000", border_style="thick"), right=Side(color="000000", border_style="thick"), top=Side(color="000000", border_style="thick"), bottom=Side(color="000000", border_style="thick") ) # 设置行颜色 for row_num in range(2, len(student) + 2): color = "FF0000" if row_num % 2 == 0 else "00BFFF" # 偶数行红色，奇数行蓝色 for cell in ws[row_num]: = Font(color=color) # 设置字体颜色 # 添加图片 image_path = 'E:/Python/class4/' img = Image(image_path) = 'F2' # 使用字符串表示单元格位置 ws.add_image(img) # 合并单元格 merge_row = len(student) + 2 ws.merge_cells(start_row=merge_row, start_column=1, end_row=merge_row, end_column=5) (row=merge_row, column=1).value = "说明：这只是个测试。" (row=merge_row, column=1).font = Font(bold=True) # 保存工作簿 (excel) print(f"已经生成表格{excel}")
数据结构与算法——顺序表和链表的优缺点（区别、特点）详解
HTML 和 JavaScript 有什么关系？