Python实现Excel文件生成

谁践踏了优雅 2023-06-12 12:30 28阅读 0赞

import xlwt
    
    # 关于样式
    style_head = xlwt.XFStyle()  # 初始化样式
    red_style_head = xlwt.XFStyle()  # 初始化样式
    green_style_head = xlwt.XFStyle()  # 初始化样式
    
    font = xlwt.Font()  # 初始化字体相关
    font.name = "微软雅黑"
    font.bold = True
    font.colour_index = 0  # TODO 必须是数字索引
    
    font_s = xlwt.Font()  # 初始化字体相关
    font_s.name = "微软雅黑"
    font_s.bold = True
    font_s.colour_index = 1  # TODO 必须是数字索引
    
    red_bg = xlwt.Pattern()  # 初始背景图案
    red_bg.pattern = xlwt.Pattern.SOLID_PATTERN  # May be: NO_PATTERN, SOLID_PATTERN, or 0x00 through 0x1
    red_bg.pattern_fore_colour = 2  # May be: 8 through 63. 0 = Black, 1 = White, 2 = Red, 3 = Green, 4 = Blue, 5 = Yellow, 6 = Magenta, 7 = Cyan, 16 = Maroon, 17 = Dark Green, 18 = Dark Blue, 19 = Dark Yellow , almost brown), 20 = Dark Magenta, 21 = Teal, 22 = Light Gray, 23 = Dark Gray
    
    green_bg = xlwt.Pattern()  # 初始背景图案
    green_bg.pattern = xlwt.Pattern.SOLID_PATTERN  # May be: NO_PATTERN, SOLID_PATTERN, or 0x00 through 0x1
    green_bg.pattern_fore_colour = 3
    
    # 设置字体
    style_head.font = font
    
    red_style_head.font = font_s
    green_style_head.font = font_s
    # 设置背景
    red_style_head.pattern = red_bg
    green_style_head.pattern = green_bg
    
    # 创建一个excel
    excel = xlwt.Workbook()
    # 添加工作区
    sheet = excel.add_sheet("数据报表")
    
    # 标题信息
    head = ["序列号", "00", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "1", "13", "14", "15", "16",
            "17",
            "18", "19", "20", "21", "22", "23"]
    for index, value in enumerate(head):
        sheet.write(0, index, value, style_head)
    
    # 内容信息
    content = [("Caaaaaa","0", "1", "0", "1", "0", "1", "0", "1", "0", "1", "0", "1", "0", "1", "0", "1", "0", "1", "0",
                "1", "0", "1", "0", "0")]
    for index, value_list in enumerate(content, 1):
        for i, value in enumerate(value_list):
            if str(value) == '0':
                sheet.write(index, i, value, red_style_head)
            else:
                sheet.write(index, i, value, green_style_head)
    
    # 保存excel
    excel.save("write.xlsx")

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTk4MDEx_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTk4MDEx_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191113093254334.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTk4MDEx,size_16,color_FFFFFF,t_70