panes.py 1.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. #!/usr/bin/env python
  2. # -*- coding: windows-1251 -*-
  3. # Copyright (C) 2005 Kiseliov Roman
  4. from xlwt import *
  5. w = Workbook()
  6. ws1 = w.add_sheet('sheet 1')
  7. ws2 = w.add_sheet('sheet 2')
  8. ws3 = w.add_sheet('sheet 3')
  9. ws4 = w.add_sheet('sheet 4')
  10. ws5 = w.add_sheet('sheet 5')
  11. ws6 = w.add_sheet('sheet 6')
  12. for i in range(0x100):
  13. ws1.write(i//0x10, i%0x10, i)
  14. for i in range(0x100):
  15. ws2.write(i//0x10, i%0x10, i)
  16. for i in range(0x100):
  17. ws3.write(i//0x10, i%0x10, i)
  18. for i in range(0x100):
  19. ws4.write(i//0x10, i%0x10, i)
  20. for i in range(0x100):
  21. ws5.write(i//0x10, i%0x10, i)
  22. for i in range(0x100):
  23. ws6.write(i//0x10, i%0x10, i)
  24. ws1.panes_frozen = True
  25. ws1.horz_split_pos = 2
  26. ws2.panes_frozen = True
  27. ws2.vert_split_pos = 2
  28. ws3.panes_frozen = True
  29. ws3.horz_split_pos = 1
  30. ws3.vert_split_pos = 1
  31. ws4.panes_frozen = False
  32. ws4.horz_split_pos = 12
  33. ws4.horz_split_first_visible = 2
  34. ws5.panes_frozen = False
  35. ws5.vert_split_pos = 40
  36. ws4.vert_split_first_visible = 2
  37. ws6.panes_frozen = False
  38. ws6.horz_split_pos = 12
  39. ws4.horz_split_first_visible = 2
  40. ws6.vert_split_pos = 40
  41. ws4.vert_split_first_visible = 2
  42. w.save('panes.xls')