Re: SOLID_PATTERN cells always show as solid black

[John Machin]

On Oct 12, 11:04 pm, James Stocks <jsto...@gmail.com> wrote:

> wbBGPattern.pattern_fore_color = 3

You have misspelled/miscopied "colour". Avoid similar problems and
make your code more legible by using easyxf. See the tutorial that you
can access via www.python-excel.org

[James Stocks]

Thanks John - I realised my mistake after closely examining my lines of code to the examples. I think I got confused because some parts of xlwt (Style.py line 514) seem to provide mapping of the Americanised (Americanized? ;) ) spelling of color.

I do spell it "colour" by the way, I'm just used to programming languages using "color"

Cheers, and thanks for an extremely useful and otherwise straightforward to use module :)

[John Yeung]

On Tue, Oct 16, 2012 at 7:47 AM, James Stocks <jst...@gmail.com> wrote:
> I think I got confused because some parts of xlwt (Style.py
> line 514) seem to provide mapping

Yes, you'll notice that the mapping gets used by easyxf; thus John
Machin's recommendation. The other part of his recommendation is to
refer to the tutorial at www.python-excel.org. That is the de facto
manual for xlwt (and xlrd and xlutils).

John Y.