python生成excel数据并实现隔行变色

代码

from openpyxl import Workbook
from datetime import date
from openpyxl.styles import PatternFilldef create_excel():wb = Workbook()sh = wb.activerows = [['Date', 'Batch 1', 'Batch 2', 'Batch 3'],[date(2024, 2, 1), 40, 30, 25],[date(2024, 2, 2), 40, 25, 30],[date(2024, 2, 3), 50, 30, 45],[date(2024, 2, 4), 30, 25, 40],[date(2024, 2, 5), 25, 35, 30],[date(2024, 2, 6), 20, 40, 35],]for row in rows:sh.append(row)# 修改样式 - 填充背景色bak_color = PatternFill('solid', fgColor='AEEEEE')for i in range(1, sh.max_row + 1):if i % 2 == 0:  # 如果行号能被2整除,就是偶数for cell in range(1, sh.max_column + 1):sh.cell(i, cell).fill = bak_colorwb.save('隔行变色.xlsx')if __name__ == "__main__":create_excel()

执行结果：