merged0.py 517 B

123456789101112131415161718192021222324252627282930
  1. #!/usr/bin/env python
  2. # -*- coding: windows-1251 -*-
  3. # Copyright (C) 2005 Kiseliov Roman
  4. from xlwt import *
  5. wb = Workbook()
  6. ws0 = wb.add_sheet('sheet0')
  7. fnt = Font()
  8. fnt.name = 'Arial'
  9. fnt.colour_index = 4
  10. fnt.bold = True
  11. borders = Borders()
  12. borders.left = 6
  13. borders.right = 6
  14. borders.top = 6
  15. borders.bottom = 6
  16. style = XFStyle()
  17. style.font = fnt
  18. style.borders = borders
  19. ws0.write_merge(3, 3, 1, 5, 'test1', style)
  20. ws0.write_merge(4, 10, 1, 5, 'test2', style)
  21. ws0.col(1).width = 0x0d00
  22. wb.save('merged0.xls')