Excel database module

[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.

Thanks,
GEM

[Dennis Lee Bieber]

On Sun, 09 May 2004 18:38:04 -0400, Garret McGraw
<ga***********@yahoo.com> 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).

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

[Brian Kelley]

Dennis Lee Bieber wrote:

On Sun, 09 May 2004 18:38:04 -0400, Garret McGraw
<ga***********@yahoo.com> 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

[Thomas Guettler]

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

[Cy Edmunds]

"Garret McGraw" <ga***********@yahoo.com> wrote in message
news:ma**************************************@pyth on.org...

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/