col_width ModuleΒΆ

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

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

    w = Workbook()
    ws = w.add_sheet('Hey, Dude')

    for i in range(6, 80):
        fnt = Font()
        fnt.height = i*20
        style = XFStyle()
        style.font = fnt
        ws.write(1, i, 'Test')
        ws.col(i).width = 0x0d00 + i
    w.save('col_width.xls')