merged0 Module

#!/usr/bin/env python
# -*- coding: windows-1251 -*-
# Copyright (C) 2005 Kiseliov Roman
__rev_id__ = """$Id: merged0.py,v 1.3 2005/03/27 12:47:06 rvk Exp $"""

if __name__ == '__main__':
    from pyExcelerator import *

    wb = Workbook()
    ws0 = wb.add_sheet('sheet0')


    fnt = Font()
    fnt.name = 'Arial'
    fnt.colour_index = 4
    fnt.bold = True

    borders = Borders()
    borders.left = 6
    borders.right = 6
    borders.top = 6
    borders.bottom = 6

    style = XFStyle()
    style.font = fnt
    style.borders = borders

    ws0.write_merge(3, 3, 1, 5, 'test1', style)
    ws0.write_merge(4, 10, 1, 5, 'test2', style)
    ws0.col(1).width = 0x0d00

    wb.save('merged0.xls')