python操作excel(python操作excel表格)

库：xlwt

from datetime import datetime
import logging
import json
import xlwt
import os


class ExportReleaseNote():

    def __init__(self):
        self.date = datetime.now().strftime("%Y%m%d")
        self.savepath = os.path.join(BASE_DIR, "download")
        self.wb = xlwt.Workbook(encoding="utf-8")
        
        # 添加sheet
        self.ws = self.wb.add_sheet('Release Note')
        self.wski = self.wb.add_sheet('Known Issue')
        
        # 设置列宽
        self.ws.col(3).width = 256 * 80                                 
        self.wski.col(3).width = 256 * 80
        self.wski.col(5).width = 256 * 80
        
        # 字体
        self.font = xlwt.Font()
        self.font.bold = True                                                       # 加粗
        
        # 居中
        self.align = xlwt.Alignment()
        self.align.horz = xlwt.Alignment.HORZ_CENTER        # 水平居中
        self.align.vert = xlwt.Alignment.VERT_CENTER        # 垂直居中
        self.align.wrap = 1                             # 自动换行
        
        # 单元格边框
        self.border = xlwt.Borders()
        self.border.top = xlwt.Borders.THIN                         
        self.border.bottom = xlwt.Borders.THIN
        self.border.left = xlwt.Borders.THIN
        self.border.right = xlwt.Borders.THIN
        
        # 单元格颜色
        self.newstyle = xlwt.XFStyle()
        self.style = xlwt.XFStyle()
        self.pt = xlwt.Pattern()
        self.pt.pattern = xlwt.Pattern.SOLID_PATTERN
        self.pt.pattern_fore_colour = 22                # light gray
        
        # 应用到样式，在write的时候，配置样式，才生效
        # header
        self.style.pattern = self.pt
        self.style.font = self.font
        self.style.borders = self.border
        self.style.alignment = self.align
        # cell
        self.newstyle.alignment = self.align
        self.newstyle.borders = self.border
   
        # 设置行高
        self.ws.row(row).height_mismatch = True
        self.ws.row(row).height = 256 * 5