| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102 |
- #!/usr/bin/env python
- # -*- coding: windows-1251 -*-
- # Copyright (C) 2005 Kiseliov Roman
- from xlwt import *
- wb = Workbook()
- ws0 = wb.add_sheet('sheet0')
- fnt1 = Font()
- fnt1.name = 'Verdana'
- fnt1.bold = True
- fnt1.height = 18*0x14
- pat1 = Pattern()
- pat1.pattern = Pattern.SOLID_PATTERN
- pat1.pattern_fore_colour = 0x16
- brd1 = Borders()
- brd1.left = 0x06
- brd1.right = 0x06
- brd1.top = 0x06
- brd1.bottom = 0x06
- fnt2 = Font()
- fnt2.name = 'Verdana'
- fnt2.bold = True
- fnt2.height = 14*0x14
- brd2 = Borders()
- brd2.left = 0x01
- brd2.right = 0x01
- brd2.top = 0x01
- brd2.bottom = 0x01
- pat2 = Pattern()
- pat2.pattern = Pattern.SOLID_PATTERN
- pat2.pattern_fore_colour = 0x01F
- fnt3 = Font()
- fnt3.name = 'Verdana'
- fnt3.bold = True
- fnt3.italic = True
- fnt3.height = 12*0x14
- brd3 = Borders()
- brd3.left = 0x07
- brd3.right = 0x07
- brd3.top = 0x07
- brd3.bottom = 0x07
- fnt4 = Font()
- al1 = Alignment()
- al1.horz = Alignment.HORZ_CENTER
- al1.vert = Alignment.VERT_CENTER
- al2 = Alignment()
- al2.horz = Alignment.HORZ_RIGHT
- al2.vert = Alignment.VERT_CENTER
- al3 = Alignment()
- al3.horz = Alignment.HORZ_LEFT
- al3.vert = Alignment.VERT_CENTER
- style1 = XFStyle()
- style1.font = fnt1
- style1.alignment = al1
- style1.pattern = pat1
- style1.borders = brd1
- style2 = XFStyle()
- style2.font = fnt2
- style2.alignment = al1
- style2.pattern = pat2
- style2.borders = brd2
- style3 = XFStyle()
- style3.font = fnt3
- style3.alignment = al1
- style3.pattern = pat2
- style3.borders = brd3
- price_style = XFStyle()
- price_style.font = fnt4
- price_style.alignment = al2
- price_style.borders = brd3
- price_style.num_format_str = '_(#,##0.00_) "money"'
- ware_style = XFStyle()
- ware_style.font = fnt4
- ware_style.alignment = al3
- ware_style.borders = brd3
- ws0.merge(3, 3, 1, 5, style1)
- ws0.merge(4, 10, 1, 6, style2)
- ws0.merge(14, 16, 1, 7, style3)
- ws0.col(1).width = 0x0d00
- wb.save('merged1.xls')
|