Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
python-excel
Home
+ new post
About this group
Join this group
SOLID_PATTERN cells always show as solid black
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   4 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
James Stocks  
View profile  
 More options Oct 12 2012, 8:04 am
From: James Stocks <jsto...@gmail.com>
Date: Fri, 12 Oct 2012 05:04:45 -0700 (PDT)
Local: Fri, Oct 12 2012 8:04 am
Subject: SOLID_PATTERN cells always show as solid black
Print | Individual message | Show original | Report this message | Find messages by this author

Hi -

I've searched on this group and also followed an example here<http://www.youlikeprogramming.com/2011/04/examples-generating-excel-d...>
But whenever I try to fill cells with a colour, they show as solid black!
My style definition is below:

Any ideas?

Thanks


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
John Machin  
View profile  
 More options Oct 12 2012, 5:20 pm
From: John Machin <sjmac...@lexicon.net>
Date: Fri, 12 Oct 2012 14:20:55 -0700 (PDT)
Local: Fri, Oct 12 2012 5:20 pm
Subject: Re: SOLID_PATTERN cells always show as solid black
Print | Individual message | Show original | Report this message | Find messages by this author
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

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
James Stocks  
View profile  
 More options Oct 16 2012, 7:47 am
From: James Stocks <jsto...@gmail.com>
Date: Tue, 16 Oct 2012 04:47:12 -0700 (PDT)
Local: Tues, Oct 16 2012 7:47 am
Subject: Re: SOLID_PATTERN cells always show as solid black
Print | Individual message | Show original | Report this message | Find messages by this author

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 :)


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
John Yeung  
View profile  
 More options Oct 16 2012, 9:54 am
From: John Yeung <gallium.arsen...@gmail.com>
Date: Tue, 16 Oct 2012 09:53:57 -0400
Local: Tues, Oct 16 2012 9:53 am
Subject: Re: [pyxl] Re: SOLID_PATTERN cells always show as solid black
Print | Individual message | Show original | Report this message | Find messages by this author

On Tue, Oct 16, 2012 at 7:47 AM, James Stocks <jsto...@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.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google