#!/usr/bin/env python
# This example script was ported from Perl Spreadsheet::WriteExcel module.
# The author of the Spreadsheet::WriteExcel module is John McNamara
# <jmcnamara@cpan.org>
__revision__ = """$Id: panes.py,v 1.9 2004/01/31 18:56:07 fufff Exp $"""
#######################################################################
#
# Example of using the WriteExcel module to create worksheet panes.
#
# reverse('(c)'), May 2001, John McNamara, jmcnamara@cpan.org
#
import pyXLWriter as xl
workbook = xl.Writer("panes.xls")
worksheet1 = workbook.add_worksheet('Panes 1')
worksheet2 = workbook.add_worksheet('Panes 2')
worksheet3 = workbook.add_worksheet('Panes 3')
worksheet4 = workbook.add_worksheet('Panes 4')
# Frozen panes
worksheet1.freeze_panes(1, 0) # 1 row
worksheet2.freeze_panes(0, 1) # 1 column
worksheet3.freeze_panes(1, 1) # 1 row and column
# Un-frozen panes. The divisions must be specified in terms of row and column
# dimensions. The default row height is 12.75 and the default column width
# is 8.43
#
worksheet4.thaw_panes(12.75, 8.43, 1, 1) # 1 row and column
#######################################################################
#
# Set up some formatting and text to highlight the panes
#
header = workbook.add_format()
header.set_color('white')
header.set_align('center')
header.set_align('vcenter')
header.set_pattern()
header.set_fg_color('green')
center = workbook.add_format()
center.set_align('center')
#######################################################################
#
# Sheet 1
#
worksheet1.set_column('A:I', 16)
worksheet1.set_row(0, 20)
worksheet1.set_selection('C3')
for i in xrange(0, 8+1):
worksheet1.write([0, i], 'Scroll down', header)
for i in xrange(1, 100+1):
for j in xrange(0, 8+1):
worksheet1.write([i, j], i+1, center)
#######################################################################
#
# Sheet 2
#
worksheet2.set_column('A:A', 16)
worksheet2.set_selection('C3')
for i in xrange(0, 49+1):
worksheet2.set_row(i, 15)
worksheet2.write([i, 0], 'Scroll right', header)
for i in xrange(0, 49+1):
for j in xrange(1, 25+1):
worksheet2.write([i, j], j, center)
#######################################################################
#
# Sheet 3
#
worksheet3.set_column('A:Z', 16)
worksheet3.set_selection('C3')
for i in xrange(1, 25+1):
worksheet3.write([0, i], 'Scroll down', header)
for i in xrange(1, 49+1):
worksheet3.write([i, 0], 'Scroll right', header)
for i in xrange(1, 49+1):
for j in xrange(1, 25+1):
worksheet3.write([i, j], j, center)
#######################################################################
#
# Sheet 4
#
worksheet4.set_selection('C3')
for i in xrange(1, 25+1):
worksheet4.write([0, i], 'Scroll', center)
for i in xrange(1, 49+1):
worksheet4.write([i, 0], 'Scroll', center)
for i in xrange(1, 49+1):
for j in xrange(1, 25+1):
worksheet4.write([i, j], j, center)
workbook.close()
|