xlwt的一些用法

最近用到了部分xlwt的部分用法，做以记录，学习补充！

1.新建excel表

        wk = xlwt.Workbook() 
        sh = wk.add_sheet("shee1")

2.写入数据

        sh.write(row,col,"str",style)
        # row是行，col为列，style为样式

3.新增样式

      style = xlwt.XFStyle() #可以设置6个样式类，font,borders,aligment,pattern,protection,num_format_str
      #1.字体样式
      font = xlwt.Font()
      font.height = 0x00C8  #默认高度
      font.italic = false #默认不设置斜体
      style.font = font
      #2.边框
      borders = xlwt.Borders()
      borders.right = borders.THIN #有多种类型可选，也可以直接写数字代替
      borders.top = borders.THIN
      borders.bottom = borders.THIN
      style.borders = borders
      #3.aligment设置
      aligment = xlwt.Aligment()
      aligment.vert = aligment.VERT_CENTER #垂直居中
      aligment.horz = aligment.HORZ_CENTER #水平居中
      aligment.wrap = aligment.WRAP_AT_RIGHT #自动换行
      style.aligment = aligment
      #4.背景色pattern
      pattern = xlwt.pattern()
      pattern.pattern = pattern.SOLID_PATTERN
      pattern.pattern_fore_colour = 5 ## 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, the list goes on...
      pattern.pattern_back_colour = 4
      style.pattern = pattern
      #5.num_format_str 设置显示的样式
      style.num_format_str = "MMM-YY" #显示为月份的缩写加上年份的最后两位

xlwt还有一些其他方法，像write_merge,set_style,Formula等，还有一些样式设置，宽高的设置等。