outline.py 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. #!/usr/bin/env python
  2. # -*- coding: windows-1251 -*-
  3. # Copyright (C) 2005 Kiseliov Roman
  4. from xlwt import *
  5. fnt = Font()
  6. fnt.name = 'Arial'
  7. fnt.colour_index = 4
  8. fnt.bold = True
  9. borders = Borders()
  10. borders.left = 6
  11. borders.right = 6
  12. borders.top = 6
  13. borders.bottom = 6
  14. style = XFStyle()
  15. style.font = fnt
  16. style.borders = borders
  17. wb = Workbook()
  18. ws0 = wb.add_sheet('Rows Outline')
  19. ws0.write_merge(1, 1, 1, 5, 'test 1', style)
  20. ws0.write_merge(2, 2, 1, 4, 'test 1', style)
  21. ws0.write_merge(3, 3, 1, 3, 'test 2', style)
  22. ws0.write_merge(4, 4, 1, 4, 'test 1', style)
  23. ws0.write_merge(5, 5, 1, 4, 'test 3', style)
  24. ws0.write_merge(6, 6, 1, 5, 'test 1', style)
  25. ws0.write_merge(7, 7, 1, 5, 'test 4', style)
  26. ws0.write_merge(8, 8, 1, 4, 'test 1', style)
  27. ws0.write_merge(9, 9, 1, 3, 'test 5', style)
  28. ws0.row(1).level = 1
  29. ws0.row(2).level = 1
  30. ws0.row(3).level = 2
  31. ws0.row(4).level = 2
  32. ws0.row(5).level = 2
  33. ws0.row(6).level = 2
  34. ws0.row(7).level = 2
  35. ws0.row(8).level = 1
  36. ws0.row(9).level = 1
  37. ws1 = wb.add_sheet('Columns Outline')
  38. ws1.write_merge(1, 1, 1, 5, 'test 1', style)
  39. ws1.write_merge(2, 2, 1, 4, 'test 1', style)
  40. ws1.write_merge(3, 3, 1, 3, 'test 2', style)
  41. ws1.write_merge(4, 4, 1, 4, 'test 1', style)
  42. ws1.write_merge(5, 5, 1, 4, 'test 3', style)
  43. ws1.write_merge(6, 6, 1, 5, 'test 1', style)
  44. ws1.write_merge(7, 7, 1, 5, 'test 4', style)
  45. ws1.write_merge(8, 8, 1, 4, 'test 1', style)
  46. ws1.write_merge(9, 9, 1, 3, 'test 5', style)
  47. ws1.col(1).level = 1
  48. ws1.col(2).level = 1
  49. ws1.col(3).level = 2
  50. ws1.col(4).level = 2
  51. ws1.col(5).level = 2
  52. ws1.col(6).level = 2
  53. ws1.col(7).level = 2
  54. ws1.col(8).level = 1
  55. ws1.col(9).level = 1
  56. ws2 = wb.add_sheet('Rows and Columns Outline')
  57. ws2.write_merge(1, 1, 1, 5, 'test 1', style)
  58. ws2.write_merge(2, 2, 1, 4, 'test 1', style)
  59. ws2.write_merge(3, 3, 1, 3, 'test 2', style)
  60. ws2.write_merge(4, 4, 1, 4, 'test 1', style)
  61. ws2.write_merge(5, 5, 1, 4, 'test 3', style)
  62. ws2.write_merge(6, 6, 1, 5, 'test 1', style)
  63. ws2.write_merge(7, 7, 1, 5, 'test 4', style)
  64. ws2.write_merge(8, 8, 1, 4, 'test 1', style)
  65. ws2.write_merge(9, 9, 1, 3, 'test 5', style)
  66. ws2.row(1).level = 1
  67. ws2.row(2).level = 1
  68. ws2.row(3).level = 2
  69. ws2.row(4).level = 2
  70. ws2.row(5).level = 2
  71. ws2.row(6).level = 2
  72. ws2.row(7).level = 2
  73. ws2.row(8).level = 1
  74. ws2.row(9).level = 1
  75. ws2.write_merge(1, 1, 1, 5, 'test 1', style)
  76. ws2.write_merge(2, 2, 1, 4, 'test 1', style)
  77. ws2.write_merge(3, 3, 1, 3, 'test 2', style)
  78. ws2.write_merge(4, 4, 1, 4, 'test 1', style)
  79. ws2.write_merge(5, 5, 1, 4, 'test 3', style)
  80. ws2.write_merge(6, 6, 1, 5, 'test 1', style)
  81. ws2.write_merge(7, 7, 1, 5, 'test 4', style)
  82. ws2.write_merge(8, 8, 1, 4, 'test 1', style)
  83. ws2.write_merge(9, 9, 1, 3, 'test 5', style)
  84. ws2.col(1).level = 1
  85. ws2.col(2).level = 1
  86. ws2.col(3).level = 2
  87. ws2.col(4).level = 2
  88. ws2.col(5).level = 2
  89. ws2.col(6).level = 2
  90. ws2.col(7).level = 2
  91. ws2.col(8).level = 1
  92. ws2.col(9).level = 1
  93. wb.save('outline.xls')