Newbie - Exporting Excel Spreadsheet
Marc Poulin
marc at verinet.com
Wed Dec 5 23:50:06 EST 2001
You might want to look at this:
http://www.python.org/windows/win32com/
(I guess I'm a little surprised that you are using
ODBC and SQL to retrieve data from a spreadsheet.)
Marc
In article <673dc1dc.0112051334.370c75f2 at posting.google.com>, "James
Fugard" <jfugard at traq.com> wrote:
> TIA for any help that I may get. I have a small project that I'm trying
> to do in Python...and I'm a hack at best! Here is what I'm trying to do.
> Call and capture a row in an Excel spreadsheet and then use manipulate
> the data in the cell of the various columns.
>
> Here is what I've been able to get some far:
>
> # Call all used modules
> import os,win32api,glob,odbc,dbi,time # Make the database connection
> using the system DNS MyConnection = odbc.odbc('Client_Data_Log')
> MyCursor = MyConnection.cursor()
> MyCursor.execute('SELECT * FROM "Client Data Log$"') # the sheet name
> print MyCursor.fetchall()
>
> This will give me everything + a bunch of dbi time stuff. If someone
> could tell me where to find info on calling a particular cell or a piece
> of sample code to follow(like G12 for example) that would be great.
> Thanks again. James
More information about the Python-list
mailing list