wsprops.py 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156
  1. from __future__ import print_function
  2. props = \
  3. [
  4. 'name',
  5. 'parent',
  6. 'rows',
  7. 'cols',
  8. 'merged_ranges',
  9. 'bmp_rec',
  10. 'show_formulas',
  11. 'show_grid',
  12. 'show_headers',
  13. 'panes_frozen',
  14. 'show_empty_as_zero',
  15. 'auto_colour_grid',
  16. 'cols_right_to_left',
  17. 'show_outline',
  18. 'remove_splits',
  19. 'selected',
  20. 'hidden',
  21. 'page_preview',
  22. 'first_visible_row',
  23. 'first_visible_col',
  24. 'grid_colour',
  25. 'preview_magn',
  26. 'normal_magn',
  27. 'row_gut_width',
  28. 'col_gut_height',
  29. 'show_auto_page_breaks',
  30. 'dialogue_sheet',
  31. 'auto_style_outline',
  32. 'outline_below',
  33. 'outline_right',
  34. 'fit_num_pages',
  35. 'show_row_outline',
  36. 'show_col_outline',
  37. 'alt_expr_eval',
  38. 'alt_formula_entries',
  39. 'row_default_height',
  40. 'col_default_width',
  41. 'calc_mode',
  42. 'calc_count',
  43. 'RC_ref_mode',
  44. 'iterations_on',
  45. 'delta',
  46. 'save_recalc',
  47. 'print_headers',
  48. 'print_grid',
  49. 'grid_set',
  50. 'vert_page_breaks',
  51. 'horz_page_breaks',
  52. 'header_str',
  53. 'footer_str',
  54. 'print_centered_vert',
  55. 'print_centered_horz',
  56. 'left_margin',
  57. 'right_margin',
  58. 'top_margin',
  59. 'bottom_margin',
  60. 'paper_size_code',
  61. 'print_scaling',
  62. 'start_page_number',
  63. 'fit_width_to_pages',
  64. 'fit_height_to_pages',
  65. 'print_in_rows',
  66. 'portrait',
  67. 'print_not_colour',
  68. 'print_draft',
  69. 'print_notes',
  70. 'print_notes_at_end',
  71. 'print_omit_errors',
  72. 'print_hres',
  73. 'print_vres',
  74. 'header_margin',
  75. 'footer_margin',
  76. 'copies_num',
  77. ]
  78. from xlwt import *
  79. wb = Workbook()
  80. ws = wb.add_sheet('sheet')
  81. print(ws.name)
  82. print(ws.parent)
  83. print(ws.rows)
  84. print(ws.cols)
  85. print(ws.merged_ranges)
  86. print(ws.bmp_rec)
  87. print(ws.show_formulas)
  88. print(ws.show_grid)
  89. print(ws.show_headers)
  90. print(ws.panes_frozen)
  91. print(ws.show_empty_as_zero)
  92. print(ws.auto_colour_grid)
  93. print(ws.cols_right_to_left)
  94. print(ws.show_outline)
  95. print(ws.remove_splits)
  96. print(ws.selected)
  97. # print ws.hidden
  98. print(ws.page_preview)
  99. print(ws.first_visible_row)
  100. print(ws.first_visible_col)
  101. print(ws.grid_colour)
  102. print(ws.preview_magn)
  103. print(ws.normal_magn)
  104. #print ws.row_gut_width
  105. #print ws.col_gut_height
  106. print(ws.show_auto_page_breaks)
  107. print(ws.dialogue_sheet)
  108. print(ws.auto_style_outline)
  109. print(ws.outline_below)
  110. print(ws.outline_right)
  111. print(ws.fit_num_pages)
  112. print(ws.show_row_outline)
  113. print(ws.show_col_outline)
  114. print(ws.alt_expr_eval)
  115. print(ws.alt_formula_entries)
  116. print(ws.row_default_height)
  117. print(ws.col_default_width)
  118. print(ws.calc_mode)
  119. print(ws.calc_count)
  120. print(ws.RC_ref_mode)
  121. print(ws.iterations_on)
  122. print(ws.delta)
  123. print(ws.save_recalc)
  124. print(ws.print_headers)
  125. print(ws.print_grid)
  126. #print ws.grid_set
  127. print(ws.vert_page_breaks)
  128. print(ws.horz_page_breaks)
  129. print(ws.header_str)
  130. print(ws.footer_str)
  131. print(ws.print_centered_vert)
  132. print(ws.print_centered_horz)
  133. print(ws.left_margin)
  134. print(ws.right_margin)
  135. print(ws.top_margin)
  136. print(ws.bottom_margin)
  137. print(ws.paper_size_code)
  138. print(ws.print_scaling)
  139. print(ws.start_page_number)
  140. print(ws.fit_width_to_pages)
  141. print(ws.fit_height_to_pages)
  142. print(ws.print_in_rows)
  143. print(ws.portrait)
  144. print(ws.print_colour)
  145. print(ws.print_draft)
  146. print(ws.print_notes)
  147. print(ws.print_notes_at_end)
  148. print(ws.print_omit_errors)
  149. print(ws.print_hres)
  150. print(ws.print_vres)
  151. print(ws.header_margin)
  152. print(ws.footer_margin)
  153. print(ws.copies_num)