| 123456789101112131415161718192021222324252627282930313233343536373839404142 |
- 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')
|