Formatting cells in Excel with Python
Question: How do I format cells in Excel with python?

In particular I need to change the font of several subsequent rows to be
regular instead of bold.

Thnak you,

Alex


Answer: Using [xlwt](http://pypi.python.org/pypi/xlwt):

    
    
    from xlwt import *
    
    font0 = Font()
    font0.bold = False
    
    style0 = XFStyle()
    style0.font = font0
    
    wb = Workbook()
    ws0 = wb.add_sheet('0')
    
    ws0.write(0, 0, 'myNormalText', style0)
    
    font1 = Font()
    font1.bold = True
    
    style1 = XFStyle()
    style1.font = font1
    
    ws0.write(0, 1, 'myBoldText', style1)
    
    wb.save('format.xls')
    

