Importing xlrd

[Chanman]

This is probably a simple question to most of you, but here goes.
I've downloaded the xlrd (version 0.6.1) module and placed in in the
site-packages folder.  Now, when I write a script, I type:

import sys
import xlrd

When I run it, there is an import error saying there is no module
named xlrd.  However when I type sys.path, the site-packages folder is
definitely in the path.  Do I somehow need to run the xlrd setup.py
first before importing?

Any help would be appreciated.
--
http://mail.python.org/mailman/listinfo/python-list

Re: Importing xlrd

[Chanman]

On Jun 2, 5:48 pm, John Machin <[EMAIL PROTECTED]> wrote:
> On Jun 3, 8:23 am, Chanman <[EMAIL PROTECTED]> wrote:
>
> > This is probably a simple question to most of you, but here goes.
> > I've downloaded the xlrd (version 0.6.1) module and placed in in the
> > site-packages folder.  Now, when I write a script, I type:
>
> > import sys
> > import xlrd
>
> > When I run it, there is an import error saying there is no module
> > named xlrd.  However when I type sys.path, the site-packages folder is
> > definitely in the path.  Do I somehow need to run the xlrd setup.py
> > first before importing?
>
> > Any help would be appreciated.
>
> From the xlrd home-page (http://www.lexicon.net/sjmachin/xlrd.htm):
> """
> Installation:
>
> * Windows only: download and run this installer
> xlrd-0.6.1.win32.exe. Any platform: download this ZIP file
> xlrd-0.6.1.zip which you unzip into a suitable directory, then cd to
> that directory, and do "python setup.py install".
> """
>
> From the xlrd README file:
> """
> Installation:
>
> * On Windows: use the installer.
> * Any OS: Unzip the .zip file into a suitable directory, chdir to
> that directory, then do "python setup.py install".
> * If PYDIR is your Python installation directory: the main files
> are in PYDIR/Lib/site-packages/xlrd (except for Python 2.1 where they
> will be in PYDIR/xlrd), the docs are in the doc subdirectory, and
> there's a sample script: PYDIR/Scripts/runxlrd.py
> * If os.sep != "/": make the appropriate adjustments.
> """

Thanks, turns out I just had to type "setup.py install" in the command
line, no "python" required.

Bryan
--
http://mail.python.org/mailman/listinfo/python-list

[xlwt] Changing Cell Background Color

[Chanman]

I've posted this on the python-excel group, but perhaps people here
know what to do.

How does one change the cell background color using the xlwt module?
I've looked at several tutorials but none show how to change the
background color.  I've tried the following:

badBG = xlwt.Pattern()
badBG.SOLID_PATTERN = 0x34
badBG.NO_PATTERN = 0x34
badBG.pattern_fore_colour = 0x34
badBG.pattern_back_colour = 0x34

badFontStyle = xlwt.XFStyle()
badFontStyle.Pattern = badBG

sheet1.write(1,1,'hello world', badFontStyle)

However, the background cell color still remains white.  Any help
appreciated.
--
http://mail.python.org/mailman/listinfo/python-list