xlwt row height example

wraptest.py

#!/usr/bin/env python

import xlwt

def wraptest():
    wb = xlwt.Workbook()
    sty = xlwt.XFStyle()
    al = xlwt.Alignment()
    al.wrap = xlwt.Alignment.WRAP_AT_RIGHT
    sty.alignment = al
    ws = wb.add_sheet('x')
    strg = "very very very very very very very long string to test the auto resizing feature"
    ws.write(0, 0, strg, sty) # row's height is adjusted correctly
    ws.write(1, 0, strg, sty) # row's height is not adjusted!
    wb.save('wraptest.xls')

if __name__ == "__main__":
    wraptest()