«

Has anybody heard of or know of a python module for
reading/parsing/writing microsoft excel databases?
Any response would be greatly appreciated.

Thanks,
GEM

On Sun, 09 May 2004 18:38:04 -0400, Garret McGraw
<> declaimed the following in comp.lang.python:

> Has anybody heard of or know of a python module for
> reading/parsing/writing microsoft excel databases?
> Any response would be greatly appreciated.
>
Assuming this is meant to run on a Windows system that also has
Excel installed, the common view is: let Excel do the work -- ie, use
the win32 python extensions to access the Excel system as a COM object
(hope I have the proper terminology -- I've not done it).

--
> ================================================== ============ <
> | Wulfraed Dennis Lee Bieber KD6MOG <
> | Bestiaria Support Staff <
> ================================================== ============ <
> Home Page: <http://www.dm.net/~wulfraed/> <
> Overflow Page: <http://wlfraed.home.netcom.com/> <

Dennis Lee Bieber wrote:
> On Sun, 09 May 2004 18:38:04 -0400, Garret McGraw
> <> declaimed the following in comp.lang.python:
>
>
>>Has anybody heard of or know of a python module for
>>reading/parsing/writing microsoft excel databases?
>>Any response would be greatly appreciated.
>>
I have not found a good reader yet, although there is a capable writer here:

http://sourceforge.net/projects/pyxlwriter/

There is a perl module that can read and write excel documents that this
package is based on.

If you follow the COM route, do your self a favor and pick up a copy of
Python Win32 Programming.

Brian

Am Sun, 09 May 2004 18:38:04 -0400 schrieb Garret McGraw:

> Has anybody heard of or know of a python module for
> reading/parsing/writing microsoft excel databases?
> Any response would be greatly appreciated.

Hi,

you can store the files as xml and process this.

Maybe this helps you:
http://aspn.activestate.com/ASPN/Coo.../Recipe/192914

Thomas

"Garret McGraw" <> wrote in message
news:mailman.382.1084143082.25742.python-...
> Has anybody heard of or know of a python module for
> reading/parsing/writing microsoft excel databases?
> Any response would be greatly appreciated.
>
> Thanks,
> GEM
>

If you really mean "database" you can do whatever you like using odbc. Fire
up your Data Sources program (under Control Panel/Administrative Tools in
XP) and do an Add/Microsoft Excel Driver. You will have to browse for the
Excel file and give the connection a name. Let's say you pick "Melvin". Then
in Python:

import odbc
import dbi
dbc = odbc.odbc("Melvin")
crsr = dbc.cursor()
sql = "select foo from bar;"
crsr.execute(sql)
print crsr.fetchone()
dbc.close()

"bar" is a named range in the workbook which contains column headings, one
of which is "foo". If it looks like:

foo baz bref
2 3 5
7 9 1

your program will print out:

(2,)

How well does all this work in practice? No idea. I just tried it for the
first time and all I can say is it worked OK for my trivial example.

--
Cy
http://home.rochester.rr.com/cyhome/