panes2.py 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. #!/usr/bin/env python
  2. # -*- coding: ascii -*-
  3. # portions Copyright (C) 2005 Kiseliov Roman
  4. import xlwt
  5. w = xlwt.Workbook()
  6. sheets = [w.add_sheet('sheet ' + str(sheetx+1)) for sheetx in range(7)]
  7. ws1, ws2, ws3, ws4, ws5, ws6, ws7 = sheets
  8. for sheet in sheets:
  9. for i in range(0x100):
  10. sheet.write(i // 0x10, i % 0x10, i)
  11. H = 1
  12. V = 2
  13. HF = H + 2
  14. VF = V + 2
  15. ws1.panes_frozen = True
  16. ws1.horz_split_pos = H
  17. ws1.horz_split_first_visible = HF
  18. ws2.panes_frozen = True
  19. ws2.vert_split_pos = V
  20. ws2.vert_split_first_visible = VF
  21. ws3.panes_frozen = True
  22. ws3.horz_split_pos = H
  23. ws3.vert_split_pos = V
  24. ws3.horz_split_first_visible = HF
  25. ws3.vert_split_first_visible = VF
  26. H = 10
  27. V = 12
  28. HF = H + 2
  29. VF = V + 2
  30. ws4.panes_frozen = False
  31. ws4.horz_split_pos = H * 12.75 # rows
  32. ws4.horz_split_first_visible = HF
  33. ws5.panes_frozen = False
  34. ws5.vert_split_pos = V * 8.43 # rows
  35. ws5.vert_split_first_visible = VF
  36. ws6.panes_frozen = False
  37. ws6.horz_split_pos = H * 12.75 # rows
  38. ws6.horz_split_first_visible = HF
  39. ws6.vert_split_pos = V * 8.43 # cols
  40. ws6.vert_split_first_visible = VF
  41. ws7.split_position_units_are_twips = True
  42. ws7.panes_frozen = False
  43. ws7.horz_split_pos = H * 250 + 240 # twips
  44. ws7.horz_split_first_visible = HF
  45. ws7.vert_split_pos = V * 955 + 410 # twips
  46. ws7.vert_split_first_visible = VF
  47. w.save('panes2.xls')