1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
from xlwt import Workbook
from xlwt.BIFFRecords import PanesRecord
w = Workbook()
# do each of the 4 scenarios with each of the 4 possible
# active pane settings
for px,py in (
(0,0), # no split
(0,10), # horizontal split
(10,0), # vertical split
(10,10), # both split
):
for active in range(4):
# 0 - logical bottom-right pane
# 1 - logical top-right pane
# 2 - logical bottom-left pane
# 3 - logical top-left pane
# only set valid values:
if active not in PanesRecord.valid_active_pane.get(
(int(px > 0),int(py > 0))
):
continue
sheet = w.add_sheet('px-%i py-%i active-%i' %(
px,py,active
))
for rx in range(20):
for cx in range(20):
sheet.write(rx,cx,'R%iC%i'%(rx,cx))
sheet.panes_frozen = False
sheet.vert_split_pos = px * 8.43
sheet.horz_split_pos = py * 12.75
sheet.active_pane = active
w.save('panes3.xls')
|
