Python - excel - xlwt: colouring every second row

Posted by konjo on Stack Overflow See other posts from Stack Overflow or by konjo
Published on 2010-06-05T17:18:47Z Indexed on 2010/06/05 17:22 UTC
Read the original article Hit count: 325

Filed under:
|
|

Hi,

i just finish some MYSQL to excel script with xlwt and I need to colour every second row for easy reading.

I have tried this:

row = easyxf('pattern: pattern solid, fore_colour blue')

for i in range(0,10,2):

ws0.row(i).set_style(row)

Alone this colouring is fine, but when when I write my data rows are again white.

Can some please show me some example 'cuz I m lost in coding :/

Best Regards.

© Stack Overflow or respective owner

Related posts about python

Related posts about excel