Re: xlrd cell background color

2008-08-14 Thread patrick . waldo
Thank you very much. I did not know there was a python-excel group, which I will certainly take note of in the future. The previous post answered my question, but I wanted to clarify the difference between xf.background.background_colour_index, xf.background.pattern_colour_index, and book.colour_

Re: xlrd cell background color

2008-08-13 Thread John Machin
On Aug 14, 6:03 am, [EMAIL PROTECTED] wrote in news:comp.lang.python thusly: > Hi all, > > I am trying to figure out a way to read colors with xlrd, but I did > not understand the formatting.py module. It is complicated, because it is digging out complicated info which varies in somewhat arbitrary

xlrd cell background color

2008-08-13 Thread patrick . waldo
Hi all, I am trying to figure out a way to read colors with xlrd, but I did not understand the formatting.py module. Basically, I want to sort rows that are red or green. My initial attempt discovered that >>>print cell text:u'test1.txt' (XF:22) text:u'test2.txt' (XF:15) text:u'test3.txt' (XF:15